Emaiing All Rows From Google Sheet?

How To
,
1

i have a scenario where I kick it off when a new row is added to a google sheet. The end of that process is a gmail. During testing, when I use my email address as the user, I receive every output (row) from the google sheet and not just the most recent one I added. Any tips on how i can easily just get the most recent input and not the entire sheet? Not developer here so looking for a simple solution. Thanks!

2 Likes
3

Hi @Steven_Connolly
Could you share the screen shot of the blueprint, so that we could further assist you.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

4

Hi @Steven_Connolly

Make sure you’re using the “Watch New Rows” module in your scenario, and that it’s configured to start watching from now (not from all existing rows). This way, only the new rows added after setup will trigger the scenario — not the entire sheet.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

5

image
image1751×579 81.1 KB

this is the total scenario. The path on the bottom is the last to run, so it has the last API call and then the email step as the final one.

6

I do have Watch New Rows as the initial step, but I do not see where it’s configurable to start watching from ‘now’. the option doesn’t seem to be available when I open the module to edit info on the sheet/rows.

image
image423×467 25.2 KB

7

Hey Steven,

and what are you sending in the gmail module? Can you show its configuration?

8

it’s a pretty simple set up. text removed in screenshot.

image
image256×852 33 KB

9

And you want to get a separate email for each row in the sheet?

Or an email with all the rows in the sheet?

10

it’s set up so that it triggers with each new row and I have several API calls set to go with data based upon that new row. The data is then added into defined columns back into the google sheet. I have several “wait” and “search” modules built in to make sure the data is there before taking the retreived data and sending it to the 1 email for that row. What happens now is that when i test it (using the same email address) i receive a separate email for every row that I’ve previously entered. So i want to avoid a similar behavior if a user does the same thing, going through the process more than 1x with their email.

11

Add a new column at the end of the sheet called Processed or something. Then when the email is sent have it update that column for that specific row. Then at the start of the scenario make sure that row is empty. Like put a filter after the watch module to check if row processed is empty.

This way even if the queue gets reset for some reason, only truly new rows will be processed.

1 Like