Support > Apps > Google Spreadsheet App

Apps: Google Spreadsheet App

. You can use a Google Spreadsheet App to track the screenshots and tracker information. You can use it to track Amazon prices, Google Search Rank, Amazon Category Rank, YouTube view counts, and more.


Note that this differs from using a Google Spreadsheet as the source for the capture. 


Prepare your spreadsheet

Use column headers to track the information available with the Blitapp capture. You can include any of these columns in any order:

  • Date: the date at which the capture was taken
  • URL: the URL of the web page captured
  • Screenshot: the URL of the screesnhto taken by Blitapp
  • Status: the status of the screenshot - Finished, or Error
  • Tracker: the name of the tracker you want to include, such as Amazon Category Rank, Google Search Rank, etc.


If you include any tracker, make sure the column header matches the tracker's name exactly. You can always ask us to create more trackers for specific pages.


Here is a simple Google spreadsheet we'll use as an example:


Amazon Price is the exact name of the Tracker set for the corresponding capture.


Share your spreadsheet

To give access to the spreadsheet to Blitapp, you must share it with the e-mail browshot-google-spreadsheets@spreadsheet-302000.iam.gserviceaccount.com with Editor access.


Create a Google Sheet App

Create a new App:

  • Type: Google Spreadsheet
  • Spreasheet URL: the Google spreadsheet you prepared


Click on Verify to ensure Blitapp has write access.



Set up your capture

Create a new capture in Blitapp. Enter the URL of the page(s) to capture. Add the trackers for this page. Add the Google Spreadsheet App you created.


Click on Save & Test to run the capture immediately. You will see the tracker information in the history:


The spreadsheet has been updated with the page information: