How to send emails based on specific column results in Google Sheets

How To
1

Hello, good afternoon.

I appreciate your help.

I want it to read a range of a sheet in Google Sheets and send an email only to people who have a particular result in a column.

Thanks for your help.

2

Hi, @Litefilos hope you are doing well.

  1. You can add a Google sheet search module to search rows in any specific sheet (you need to make the connection first inside the module)

  2. Then you will need an iterator module to get the results (array) in separate bundles to map the result in next module.

  3. In the next step you can use set variable or text aggregator module and use map( ) function to filter any specific column based on any specific value.

  4. You can then send the result/variable value/text to send email using email module e.g. Gmail.

Note:

You can use make academy as resources to learn about each module and map function.

Please create a scenario, test it if not successful export/screenshot and share the scenario to find more unique and specific solution by the make experts in the community.

You can also try using filter inside the Google sheet search module.

1 Like