We capture every truck load through this Google Form: https://docs.google.com/forms/d/e/1FAIpQLScOqrIgEEMD8fVPgygRbYdtDXgzhwhcSF-ftrGnIWawMcCVuQ/viewform. At the moment responses arrive in the linked sheet, yet we still copy-paste data into our master workbook and then rebuild the same details again inside Xero. I want that entire flow to happen without touching a keyboard. Scope • Every field submitted through the form must flow straight into the master spreadsheet located here: https://docs.google.com/spreadsheets/d/1HMHjp8ERbXs3aZrPGFZs6T_lsoNRjmBcU2YJMrMJ8qU/edit?pli=1&gid=2040236687#gid=2040236687 (same tab structure retained). • As soon as a new row lands, it needs to be moved to its company specific page in the sheets and would be nice to be tallied at the end of the week and saved as a draft amount in xero to invoice the company to save us counting and invoicing after manually moving every load from the form spreadsheet to their individual companies spreadsheet then tallying them to invoice the quantity of loads that week . an invoice should be created automatically in Xero using the Xero API. Line items are already saved customer, reference to be updated on the sheet and due date mirror the data in the row. No manual trigger—completely event driven. • Error handling is essential: if a submission fails to post to Xero, I need an email alert and a status flag back in the sheet. Preferred tools Google Apps Script is already enabled, but I’m open to Zapier, Make, or a lightweight Node.js cloud function if that proves cleaner. Whichever route you pick, the result has to be maintainable without deep code edits—ideally parameter-driven inside a config sheet or script properties. Deliverables - Working automation script / scenario deployed to my Google account and connected to my Xero tenant - Brief hand-over doc or Loom video walking through how to adjust mappings and auth tokens - One test run showing a form submission, sheet update, and invoice successfully appearing in Xero Acceptance criteria The end-to-end process must complete in under two minutes per submission and require zero manual intervention. Any edge cases (blank optional fields, duplicate customers) should not break the flow but still surface a clear flag for review. If you’ve wired Google Workspace to Xero before and can knock this out quickly, I’d love to get started today.