Blitapp can take a list of URLs to screenshot from a Google spreadsheet. Optionally, Blitapp can update the spreadsheet with information related to the capture: status, link to the image, and path of the screenshot uploaded through an App.
Your spreadsheet must contain one column with a list of URLs. The first row should include the name of the column. You can choose any column name and column number.
Each URL should start with http:// or https://. If the value is blank, the row will be skipped.
You can include additional columns to be updated by Blitapp. You can choose any name for these columns, and they can appear in any order. These rows should be updated by Blitapp only.
Your spreadsheet can include other columns. These will be ignored and kept as it is.
Here is a simple Google spreadsheet we'll use as an example:
To give access to the spreadsheet to Blitapp, you must share it with the e-mail email@example.com.
You can give us Viewer or Editor access:
Create a new capture in Blitapp. Choose spreadsheet as the Web Page Link type. In the URL, enter the spreadsheet URL: click on Copy Link in the share screen, or enter the URL you see in your web browser. The URL should look like this: https://docs.google.com/spreadsheets/d/1V7cHNFM2pdpRSffakk-m6W2XlMpgkHWnnXv1nyWAhC4/...
Define the columns that you want Blitapp to update. Remember that you should have at least one of these columns if you don't want the same URLs to be captured every time the capture runs.
Remember to Test Access to ensure Blitapp can read your spreadsheet and find the URL list.
Blitapp checks the columns you specified for the URL list. It will skip and empty cells. Each row will check if you set one of the other columns (image link, App, and status). If any of these cells contain a value, Blitapp will skip the URL.
If you want to regularly add URls to your spreadsheet and capture these new URLs, ensure you have at least 1 column specified for updates: status (recommended), image link, or App (with at least 1 App added to your capture). You can set your capture schedule to check the spreadsheet hour or more often to capture new URLs.
If you want to screenshot all URLs every time the capture runs, do not specify an additional column.
See also: Web Page Link