1

im stuck with an automation workflow on Make.com

I'm trying to create a flow that starts with Google Forms, once a form has been submitted, it will automatically add a new row in Sheets, and then send them a confirmation email.

However, I want to send myself an email when the first 3 forms are created, with the details that they have entered in the form. As of right now, i have everything set up correctly except the final email. I can't figure out how to pull the 3 rows of data from Sheets. I can only pull the most recent row.

Does anyone have any experience with this?

Thanks!

Tried using different parameters but couldn't find anything that worked

Pete
  • 11
  • 1

1 Answers1

0

If you know the empty row is always going to be in a expected range of rows you can use "Google Sheets" -> "Get Range Values", aggregate them into a single array and then get slice of only that last 3 array items.

For example with the following sheet I want to get that last 3 rows and send them as as single text to my Slack channel.

enter image description here

This is my setup:

enter image description here

enter image description here

I'm only selecting row range A1:A10.

The only complicated module is the "Last3" where I do the array transformation (0 is raw variable name):

enter image description here

Then sending the Slack message is pretty simple:

enter image description here enter image description here

The whole scenario consumed only 5 operations.

martin
  • 93,354
  • 25
  • 191
  • 226