Make Automation: Gmail to Sheets

I want a streamlined Make scenario that grabs every new email arriving in my Gmail inbox, parses the order details I specify, and appends them into a Google Sheets spreadsheet—automatically, every hour.

Here’s what I need set up:
• A Gmail trigger in Make polling once per hour.
• Parsing logic that captures key order fields (date, sender, subject, body text—plus any other straightforward fields you recommend).
• A Google Sheets module that writes each captured order as a new row in my existing sheet, mapping the parsed data to the right columns.
• Basic error handling and a simple log so I can quickly spot failed runs.
• Clear, step-by-step notes inside the scenario or a short doc so I can adjust filters or column mapping later.

You’re free to use Make’s built-in filters and functions; no external script is required unless it makes the flow cleaner. Once the scenario is live and tested, I’ll confirm with a few sample emails to be sure everything posts to Sheets exactly as expected.