← Back to Tutorials

How to automate screenshots of a Google Sheet

Learn how to automatically take screenshots of a Google Sheet using PagePixels.

Introduction

PagePixels is a screenshot automation solution that you can use to take automated scheduled screenshots of web pages, including a Google Sheets spreadsheet.

PagePixels is free to start, and this tutorial demonstrates how to create a screenshot automation that takes a screenshot of a Google Sheet every 15 minutes.

How to automate taking a screenshot of a Google Sheet.

To capture recurring screenshots of a Google Sheet every 15 minutes:

1

Create a screenshot

Log in to your PagePixels account, and click the "+Create Screenshot" button.

2

Set your schedule

By default, recurring screenshots are set to every 5 minutes.

To take a screenshot every 15 minutes, click into the input field with the default value 5 and change it to 15.

3

Add your URL

Copy and paste the public link for your Google Sheet into the "Website URL to Capture" field.

4

Save Screenshot

Click the green "Save Screenshot" (top-right) button.

Your screenshot automation is officially set, and your first screenshot will be taken shortly.

_____

Notes

  • The defaults for screenshots generated by PagePixels are "Page Width" (1920px), "Page Height" (1000px), and "Wait Time to Capture Screenshot" (1500ms). These settings can be changed in your screenshot configuration anytime.

What else can PagePixels do?

When you automate screenshots of your Google Sheets with PagePixels, you can also:

  • Schedule screenshots by time interval, days of the week, time of day, and time zone using PagePixels built-in scheduling system.
  • Display the latest screenshot of your Google Sheets data in your website, data visualization / business intelligence dashboard tool, and more, using a PagePixels Embed URL.
  • Post screenshots of your Google Sheets spreadsheets and dashboards to a public or private Slack channel or custom webhook address with our built-in integrations.
  • Send and save screenshots of your Google Sheets spreadsheets and dashboards to 5,000+ services with the PagePixels Screenshot Zapier app.
  • Click to view a different sheet, hover over cells, and perform other user actions on your Google Sheet before taking a screenshot with PagePixels Multi-Step functionality.
  • Track and receive an alert when changes happen to text in your Google Sheet spreadsheet using PagePixels Change Notification feature.
  • Customize the look of your Google Sheets spreadsheets and dashboards with PagePixels CSS injection feature.
  • Programmatically take scheduled and one-time screenshots of your Google Sheet spreadsheets and dashboards using the PagePixels Screenshots API.

Support

Questions? Contact us any time by email:

support-tickets@pagepixels.com

Or send us a message through our Support page.