How to capture screenshots of Google Sheets and automatically email images to Schedule to keep your team up to date with the latest data.
The finance team created a revenue dashboard within Google Sheets to track the company’s sales performance over time. The dashboard contains data tables and charts showing overall revenue and regional performance trends.
Here’s a screenshot of the Google Sheets dashboard:
The finance team wants to send a snapshot of this dashboard to the company’s management every Monday morning. They want to automate this process so that a screenshot is automatically captured and sent via email without any manual intervention.
Let’s see how we can easily set up this automation with the help of the Email Google Spreadsheet add-on. You can define the area of the Google Sheets dashboard you want to capture, using A1 notation, and the add-on will automatically take a screenshot of that area and send it to recipients via email.
Open your Google Sheets dashboard, go to Extensions > Email Google Sheets > Open to launch the app. Click the Create Workflow button and go to Email Step of the workflow.
Automatic 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 contain markers that will be replaced with actual values from the Google Sheets dashboard.
For example, if you want to include the value of a cell in an email, you can use a marker {{SheetName!A1}} where SheetName Name of the sheet A1 is the cell address.
How to insert screenshot markers
Expand Markers section of Email body and click on Image A marker for the page whose screenshot you want to include in the email. The marker will be added to the body of the email.
The format of the screenshot marker follows this format:
{{ Image:SheetName!SheetId,A1:B10 }}The SheetName Name of the page is , and A1:B10 is the range of cells you want to capture in the screenshot. The SheetId The sheet’s unique ID is used to identify the sheet in Google Spreadsheets. Even if you change the page name, the ID will not change.
When the message is ready, click Preview Button to send yourself a test email. Here’s what the email will look like:
If everything looks good, click Continue Set schedule for button and workflow.
Install Email Google Spreadsheet