How to automatically take screenshots of a range of cells in a Google Sheet

Learn how to capture a select range of cells in a Google Sheet spreadsheet using PagePixels.

Introduction

PagePixels is a screenshot automation tool that you can use to take automatic scheduled screenshots of web pages, including specific cells in a Google Sheet.

PagePixels is free to start, and this tutorial demonstrates how to create a screenshot automation that captures a select range of cells within Google Sheets on a daily schedule.

How to take scheduled screenshots of a range of cells in a Google Sheet

To take daily screenshots of a range of cells in a Google Sheet:

Create a Publish to Web link

To display only a range of cells and be accessible to PagePixels, you can use Google Sheets' "Publish to Web" option.

Click File > Share > Publish to Web

Select your sheet.

Click the Publish button.

Click OK to publish.

Copy the URL that appears in the box

Modify the URL to only display a range of cells

Open another tab and go to the "Publish to Web" link you just copied.

Return to your sheet and copy your cell range.

For example: C2:D8

Go back to your tab with the "Publish to Web" link and add a range query to the end of the URL: &range=

Paste your cell range as the value (&range=C2:D8).

For example:

Copy your modified URL to use in PagePixels.

Create a screenshot in PagePixels

Set your schedule

By default, new screenshots are set to an every 5 minute interval.

For a daily screenshot, change the values to every "1" "Days" using the input and dropdown fields.

Add your URL

Paste your modified "Publish to Web" link into the Website URL to Capture field.

Increase the Wait Time

To give your Google Sheets cells plenty of time to load, increase the Time to wait value from 1500 to 6000 (value is in milliseconds).

Save Screenshot

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

Your screenshot automation is now set, and your first Google Sheets screenshot will be taken shortly.

Need help with your Google Sheets screenshot? Send us an email: support-tickets@pagepixels.com

Frequently Asked Questions

Can I remove all the whitespace and just have the cell table appear in the screenshot?

Yes. To accomplish this:

1. Add a headers query string with value false to the end of your "Publish to Web" cell range URL in PagePixels: &headers=false

2. Add the following selector to the CSS Selector field: table

With these changes in place, your screenshot will now look something like this:

Want to modify the appearance of your screenshot even more? You can add custom styles using the CSS Injection field.

What else can PagePixels do?

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

Schedule screenshots of your Google Sheets by time interval, days of the week, time of day, and time zone using PagePixels' built-in scheduling system (no other tools required).
Automatically post screenshots of specific cells in your Google Sheets spreadsheets to a public or private Slack channel, a Custom Webhook address, or upload the images to your Dropbox account.
Leverage no-code integration platforms Zapier and Make (Integromat) to take and send Google Sheets spreadsheets and dashboards to thousands of services, such as Google Drive, Gmail, and Google Chat.
Perform a set of a pre-screenshot actions, such as click, press Enter, and hover, with PagePixels' Multi-Step Screenshot functionality.
Dynamically display the latest screenshot of your Google Sheets data in your website, dashboard, and app using a single Embed URL.
Create screenshots from your private Google Sheets data with Custom HTML Screenshots.
Automatically take Google Sheets screenshots and have an AI analyze the resulting images with the AI Analysis Screenshot feature.
Have AI compare and contrast your Google Sheet screenshot images with the Multiple Image AI Analysis feature.
Customize the look of Google Sheets spreadsheets and dashboards with PagePixels Custom CSS injection feature.
Use PagePixels' Screenshot API to programmatically capture screenshots of your Google Sheet spreadsheets and dashboards.

Explore our features page to discover even more things PagePixels can do for you.

Support

Questions? Contact us anytime by email:

support-tickets@pagepixels.com

Or send us a message through our Support page.