How to Email Screenshots of Google Sheets on a Schedule

How to capture screenshots of Google Sheets and send the images via email automatically on a schedule to keep your team updated with the latest data.

The finance team has created a revenue dashboard inside Google Sheets to track the company’s sales performance over time. The dashboard has data tables and charts showing overall revenue and regional performance trends.

Here’s a screenshot of the Google Sheets dashboard:

Google Sheets Screenshot

The finance team wants to send a snapshot of this dashboard to the company’s management every Monday morning. They would like to automate this process so that the screenshot is captured automatically and sent via email without any manual intervention.

Let’s see how we can easily set up this automation with the help of Email Google Spreadsheets add-on. You can define the area of the Google Sheets dashboard that you want to capture, using the A1 notation, and the add-on will automatically take a screenshot of that area and send it via email to the recipients.

Open your Google Sheets dashboard, go to Extensions > Email Google Sheets > Open to launch the app. Click on the Create Workflow button and move to the Email step of the workflow.

Screenshot of Google Sheets

Automate Screenshots of Google Sheets

Go to the Email step of the workflow and specify the email addresses of the recipients. The subject and body of the email can include markers that will be replaced with the actual values from the Google Sheets dashboard.

For instance, if you wish to include the value of a cell in the email, you can use the marker {{SheetName!A1}} where SheetName is the name of the sheet and A1 is the cell address.

How to Insert Screenshot Markers

Screenshot Spreadsheet markers

Expand the Markers section of the Email body and click on the Image marker for the sheet whose screenshot you want to include in the email. The marker will be added to the email body.

The format of the screenshot marker follows this pattern:

{{ Image:SheetName!SheetId,A1:B10 }}

The SheetName is the name of the sheet, and A1:B10 is the range of cells that you want to capture in the screenshot. The SheetId is the unique id of the sheet that is used to identify the sheet in the Google Spreadsheet. The id will not change even if you rename the sheet.

Once the message is ready, click the Preview button to send a test email to yourself. Here’s how the email will look like:

Gmail - Google Spreadsheet Image

If everything looks good, click the Continue button and set the schedule for the workflow.

Install Email Google Spreadsheets

Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory


Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.