Perplexity connection issues with Google Sheet

Hi all please can some one enlighten me. New to make.

Trying to comment Perplexitiy with Google sheets to summarise a blog article.

Google sheets is running fine and shows the magnifying glass when run (this is good)

Perplexity when run on its own is running fine and summarising the article.

However when running the two together Perplexity is not connecting to the google sheet BUT theres not red error warnings.

IO can work out why

Thanx

Hey Tobie,

can you send some screenshots and/or a short video demonstrating the issues? Also any input/output bundles you are getting will also be very helpful.

thank you kindly Integration Google Sheets | Make - 24 February 2025 | Loom

It runs just fine. What you are experiencing is the Watch New Rows module not finding any new rows. If you click the bubble next to it you can see that the bundle is empty.

The Watch New Rows module isn’t instant and wont trigger when a new row is added to a google sheet. It will run on a timer and every time it will check if anything new is there. Then the following modules will only do something if there are new rows in the sheet.

As an alternative I always suggest adding an App Script to your google sheet to call a Make webhook when a new row is added instead. This will both save on the unneeded executions of the time based module and will be instant.

1 Like

can’ thank you enough for quick response - can you point me in specific learning article or video regarding this “As an alternative I always suggest adding an App Script to your google sheet to call a Make webhook when a new row is added instead. This will both save on the unneeded executions of the time based module and will be instant.”

Welcome to the Make community!

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.

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).

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

See the webhook solutions posted here: Is the Google Sheets to Make app down for anyone else

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.

1 Like

Hey @Tobie_Allen I’m sure that @samliew offers a more robust solution, but I can tell you at least why the behaviour is occurring. Sheets is Watching New Rows. Literally. Or at least I had to experiment with it for a bit, but if you fully delete (Right-Click, Delete 2 rows…) in the Sheet, (so the ref to those actual rows are now toast, then you can paste the data back in place and then Sheets will trigger a New Row event.

It points to @samliew’s more eloquent description with the Webhook solution.

Btw, I’m also new here. Is there a place to create Issues? Does anyone (maybe an #admin see’s this) know if connectors are Open-Source, and if one could make a PR to, for example, a Google Watch Row module? :slight_smile:

Hey there @whoisryan :wave:

Welcome to the community, it’s super exciting to have you here! :earth_africa:

If you believe you are experiencing some technical issues, please feel free to create a ticket with our Support team as they have the right tools to further investigate this situation.

If you have an idea or a suggestion regarding some improvement or app, log them to our Idea Exchange, but don’t forget to search for them first!

Thanks!

3 Likes

Super, thanks @vendy - will do! Nice to meet you. :wave:

2 Likes