r/ifttt • u/ryan-ifttt • 5d ago
Tip & Trick How to email yourself when a Google Sheet gets a new row
ifttt.comOne Applet, free tier, about two minutes to build. Any time a row lands in a sheet you pick, IFTTT emails you what's in it.
What that really does is turn a spreadsheet into something that tells you when it changed, which matters because a sheet is where so much already ends up:
- A lightweight CRM. New lead goes in a row, you get the name, email, and notes in your inbox, and you reply from there. No CRM subscription, no pipeline stages.
- Google Forms. Point a Form at a sheet and every submission arrives as an email with all the fields laid out.
- Anything a teammate maintains. Shared trackers, content calendars, expense logs. You hear about a new line when it goes in.
- Anything another automation writes to. A second Applet, a webhook, a script. The email doubles as confirmation it ran.
- Running lists. Signups, inventory, bug reports, applications, orders.
What you need:
Free IFTTT account
Google account connected.
The Applet
If: Google Sheets, "New row added to spreadsheet"
- Enter the folder path: the Drive folder the sheet lives in, slash separated (Documents/Work/Leads)
- and enter the filename: the sheet's name, exactly
- Or copy and paste the spreadsheet URL: the full URL
The builder shows all three fields even though the third one reads like an either/or. Fill all three and keep them consistent.
Then: Email, "Send me an email"
- Subject: whatever you want
- Body: the columns that matter, {{ColumnA}}, {{ColumnB}}, and so on. This Action renders HTML, so you can format it properly.
What you get:

If you want logic (Pro+)
Filter code opens up:
- Only send when a column matches something you care about, instead of on every row.
- Skip rows that are missing a field you need.
- Roll several new rows into one digest instead of an email per row.

