Why can't I send an email after my Google Sheets 'add a row' module?

[dom_1]

Hello,

I am setting up a simple automation that gets the current weather and adds a new row to a Google Sheet every day at 9:00AM. These 2 modules work fine.

When it comes to the 3rd module (‘Send an email’) I am expecting to see the column headers appear as variables inside the content. But I can’t actually choose anything to do with my actual spreadsheet data (see screenshot with red box below). What am I doing wrong? Why can’t I see my actual spreadsheet data there?

Thanks,
Dom

[samliew]

Welcome to the Make community!

To get all of your spreadsheet data (and not just the row you added), you need to use Search Rows module instead.

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.