I collect every piece of customer feedback by email and need both the star rating and the written comment to flow into my existing Google Sheet automatically, every single day. The spreadsheet is already laid out with columns for Date, Name, Email, Rating, Comment and Product, so your task is to bridge Gmail (where the messages arrive) with Google Sheets and make sure each new email populates the next empty row without creating duplicates. You’re free to use Google Apps Script, Zapier, Make or a similar no-code option—whichever gives a reliable, hands-off workflow. I also have roughly 600 historic feedback emails; part of the job is parsing that backlog and seeding the same sheet so we start with complete data. Deliverables • A working automation that scans incoming feedback emails, extracts rating and comment fields and appends them to the correct columns in Google Sheets on a daily schedule (near real-time is fine). • One-time import of the existing email backlog. • Clear hand-off: a short README or Loom video showing how the script/zap is configured, how to tweak filters (subject line, sender, etc.), and how to restart it if anything breaks. Acceptance criteria: the sheet updates automatically for 3 consecutive days with no manual intervention and the historic data matches the sample I provide. That’s the full scope—let me know any access details you need and your preferred approach so we can get this running quickly.