How to take automatic screenshots of private Google Sheets data with Make.com

Click the + Create a new scenario button

Add Google Sheets Watch New Row Trigger module

Search for and select the Google Sheets app.

Select the Watch New Rows trigger module.

Configure Google Sheets module

Choose or connect your Google Sheets account in the "Connection" field.

Configure which spreadsheet data you want to monitor for your trigger. Click Save.

Select where you want your trigger to start. Click Save.

Add PagePixels Create a Custom HTML Screenshot module

Search for and select the PagePixels Screenshots app.

Select the Create a Custom HTML Screenshot action module.

Configure PagePixels module

Choose or connect your PagePixels account in the "Connection" field.

Add HTML tags into the "Custom HTML" field.

Click into the field and select the Google Sheets data you want to include in your screenshot. For example:

<div style="padding:20px;">
  <h1> Revenue  📊 </h1>
  <h2> {{1.`1`}}</h2>
</div>

Finish configuring your screenshot and click Save.

Use the screenshot in another Make app module.

Click the plus Add another module button.

Select your desired app and module.

For this example, we're going to choose Gmail Send an Email module.

Choose or connect your Gmail account in the "Connection" field.

Add HTML tags to the "Content" field and use the "Direct Link" item from PagePixels to add your screenshot image.

For example:

<p style="font-size: 18px;" > Your Latest Metric </p>
<img src="{{2.direct_link}}" width="1200px">

Note: You'll need to set the "Body type" field type to "Raw HTML" for this to work.

Complete the other fields to your preference and click the Save button.

Test your Scenario

Click on the "Run once" play button to test your scenario.

After a successful test run in Make, an email will send containing your Google Sheet screenshot image in the email body.

Example:

Schedule your Scenario

Click the Every 15 minutes scheduling toggle in your bottom toolbar to the "ON" position.

Set your desired schedule and click the Save button.

Click the Save icon in the bottom toolbar.

🎉 Your Make automation is now set and running on your chosen schedule.