Watch New Rows on Google sheet module seems to have an issue

Features
1

I am using a Watch New Rows module. The description indicates that this module is triggered whenever there is a new row. I keep adding rows to the spreadsheet but not seeing my scenario being triggered. I checked other posts here for solution but none of them worked.

1 Like
3

Hi @David_Balan

Watch new rows is a polling trigger in google sheet that will run on the interval you set for the scenario run. If the scenario is off, then you will have to manually run the module.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

1 Like
4

Hi @Msquare_Automation ,

Why is there an interval needed? the description says “Triggers when a row is added”. So if the adding of rows is not the real trigger, it is quite misleading.

5

Is there another way to be able to trigger a scenario whenever a new row is added?

6

Polling Triggers & Empty “Check Runs”

This is because the module is a POLLING trigger, and not an INSTANT (Webhook) trigger.

If you don’t see any bundles from the trigger module and operations on the rest of the modules, it means there are no new responses (empty output bundle) when the scenario ran to check for new items. This is called a “Check run”.

There are two main types of triggers, Polling (scheduled), and Instant (webhooks). Polling triggers can only run on a schedule. Instant triggers can be run as soon as data is received by the webhook.

  • Polling means Make checks external service for changes (pull changes to Make).
  • Webhook (instant) triggers means external service calls Make when there are new changes (push changes to Make).

The module you are using does not push changes — it’s basically a API request that Make has to occasionally “call” to fetch the latest changes/items.

To find out more on the different types of Trigger modules, see refer to Types of Modules and Webhooks sections of the Make Help Centre.

If you want your scenario to only run when there is new data (and not on a schedule or timed interval), see if your app has an “Instant” or “Webhook” trigger in Make. If not, check if the third-party service has a feature that can send out a webhook when content is created/updated - and then you can point it to a “Custom Webhook” trigger in your scenario.

If you want to re-run your scenario on older data,

Polling Triggers: Epoch Panel & Selecting Older Data

Go to the Epoch Panel, by right-clicking on the trigger module (polling triggers only), and select “Choose where to start” from the list of options in the context menu.

260Ă—187 11.7 KB

If you select “From now on”, the next time the scenario runs it will only return new data (or nothing if there is no new data).

450Ă—247 13 KB

You can also select other old data to re-run your scenario with next using the “Choose manually” option. This will then show you a list of previous historical items you can select to process the next time the scenario is triggered.

For more information, see

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

7

If you want your trigger to run immediately, you’ll need to use a Webhook “Instant” trigger, where you can set the scheduling to “Immediately”.

To do this, you can try using the Google Sheets “Watch Changes” module —

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

For more information, see https://www.make.com/en/integrations/google-sheets, and the Google Sheets page in the Make Help Centre, which covers the following:

  • Connect Google Sheets to Make
  • Set Up Google Sheets Webhooks
  • Build Google Sheets Scenarios
  • Tips & Tricks
  • Usage Limits

and also,

  • Create and configure a Google Cloud Platform project for Google Sheets
  • Sheets
  • Rows
  • Cells
  • Other
  • Deleting Multiple Rows
  • How to Get Empty Cells from a Google Sheet
  • Add a Custom Button in a Sheet to Trigger a Scenario
  • Storing Dates in a Spreadsheet
  • Exploiting Google Sheets Functions
  • How to perform a custom function?
  • Posting and Getting Images from Google Sheets

You should also take note of the following important details:

  • The Make Google Sheets Add-on is currently not available, and the following procedure should be followed to use the Perform a Function and Watch Changes instant modules.

  • It is important to paste the full webhook address into the script to avoid any errors.

  • Make sure that the Sort order and Order by fields are set as above, otherwise values will not be deleted correctly from the table!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

8

I was able to get it to work by using Watch Changes module then instead of using onEdit as a trigger on google sheet, I used onChange to be able to monitor row additions.

2 Likes