Hello. Does anyone know how I can see if a new record has been added to a Google Sheet when a mail-hook is triggered? Thank you very much.
You can see it by opening up the Google Sheet to see if a new record has been added, or by checking the scenario execution history logs.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Sorry, that’s not what I meant. What I want is to get the last record of a GOOGLE SHEET that has been filled out by a GOOGLE FORM. That is, when a record is filled out in a GOOGLE FORM and it fills out a row in the SHEET, GMAIL sends an MAIL to my account that triggers a scenario using a MAIL HOOK. When the scenario is triggered, what I want to do is get the data from that last record that is in the GOOGLE SHEET (although it would also be fine for me to get it from a GOOGLE FORM since they are the same data). Thank you very much!!!
Oh, in that case you can do this:
Sort by Descending Row Number.
Limit by 1.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Thank you very much, I will try it
I just happen to be working on a similar project. Here it is in action:
And here is the sending email settings:
Here is the sheets settings. It would be the same from a form:
1 Like
thank you Bryan for your answer