seize screenshots of Google Sheets and ship the photographs through electronic mail robotically on a schedule to maintain your crew up to date with the newest information.
The finance crew has created a income dashboard inside Google Sheets to trace the corporate’s gross sales efficiency over time. The dashboard has information tables and charts exhibiting general income and regional efficiency traits.
Right here’s a screenshot of the Google Sheets dashboard:
The finance crew desires to ship a snapshot of this dashboard to the corporate’s administration each Monday morning. They wish to automate this course of in order that the screenshot is captured robotically and despatched through electronic mail with none handbook intervention.
Let’s see how we are able to simply arrange this automation with the assistance of Email Google Spreadsheets add-on. You’ll be able to outline the world of the Google Sheets dashboard that you simply need to seize, utilizing the A1 notation, and the add-on will robotically take a screenshot of that space and ship it through electronic mail to the recipients.
Open your Google Sheets dashboard, go to Extensions > E-mail Google Sheets > Open to launch the app. Click on on the Create Workflow button and transfer to the E-mail step of the workflow.
Automate Screenshots of Google Sheets
Go to the E-mail step of the workflow and specify the e-mail addresses of the recipients. The topic and physique of the e-mail can embody markers that will likely be changed with the precise values from the Google Sheets dashboard.
For example, if you happen to want to embody the worth of a cell within the electronic mail, you should utilize the marker {{SheetName!A1}} the place SheetName is the identify of the sheet and A1 is the cell handle.
Insert Screenshot Markers
Develop the Markers part of the E-mail physique and click on on the Picture marker for the sheet whose screenshot you need to embody within the electronic mail. The marker will likely be added to the e-mail physique.
The format of the screenshot marker follows this sample:
{{ Picture:SheetName!SheetId,A1:B10 }}The SheetName is the identify of the sheet, and A1:B10 is the vary of cells that you simply need to seize within the screenshot. The SheetId is the distinctive id of the sheet that’s used to establish the sheet within the Google Spreadsheet. The id won’t change even if you happen to rename the sheet.
As soon as the message is prepared, click on the Preview button to ship a take a look at electronic mail to your self. Right here’s how the e-mail will seem like:
If the whole lot seems to be good, click on the Proceed button and set the schedule for the workflow.
