Lesson 29 lessons
Your First Scenario — Email to Spreadsheet
Planning the scenario
Goal: when a new email arrives matching a filter (e.g., subject contains "Order"), extract key details and add a row to a Google Sheet. This teaches the core pattern — trigger, extract, act.
Building it step by step
Add a Gmail "Watch Emails" trigger module with a search filter, then add a Google Sheets "Add a Row" module, mapping email fields (sender, subject, date) to spreadsheet columns using the visual field mapper.
Running and scheduling
Click "Run once" to test with real data, verify the spreadsheet row appears correctly, then set the scenario to run on a schedule (e.g., every 15 minutes) and turn it on.
Key Takeaways
- The core pattern is: trigger → extract data → act on another app.
- Use the visual field mapper to connect data between modules.
- Test with "Run once" before scheduling a scenario to run automatically.
- Scheduled scenarios need to be explicitly turned on to run recurring.
Build the email-to-spreadsheet scenario
Build a working scenario that watches your email for a filter you choose and logs matching emails to a Google Sheet.