Support > Capture Options > Google Spreadsheet
trackersBlitapp can take the list of URLs to screenshot from a Google spreadsheet. Optionally, Blitapp can also 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 contain 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. the column URL
To give access to the spreadsheet to Blitapp, you must share it with the e-mail browshot-google-spreadsheets@spreadsheet-302000.iam.gserviceaccount.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 column that you want Blitapp to update. Remember that yous should have at least one of these columns if you don't want the same URLs to be captured every time the capture runs.
All the regular capture settings can be applied: trackers, Apps, schedules, e-mail, etc.
Don't forget to Test Access to make sure 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 specified 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 add URls to your spreadsheet regularly and capture these new URls only, 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 take a screenshot of all URLs every time the capture runs, do not specify and additional column.
See also: Web Page Link