THE ALDER HOUSE (BOUTIQUE HOTEL, 22 ROOMS) - FAILED AUTOMATION RUNS THIS WEEK (Made-up hotel and guests for a Stepthrough practice lesson. The two error messages are the kind Google's Sheets and Gmail services send back; your automation tool shows them in its run history.) WHAT THE AUTOMATION DOES It was built in March by a freelancer who has since moved on. Nobody on staff built it. Step 1 Trigger: a guest submits the "Group booking inquiry" form on our website. Step 2 Google Sheets: add a row to the spreadsheet "Group Inquiries", tab "Inquiries", columns A to F (Date, Name, Email, Group size, Dates wanted, Notes). Step 3 AI step: write a short, friendly reply using the guest's name, group size and dates. Step 4 Gmail: send that reply to the guest's email address, from events@thealderhouse.example. It ran fine for 7 months: 212 successful runs. WHAT CHANGED LAST WEEK (as far as we know) - Monday: our events manager tidied the spreadsheet for 2027. She renamed the tab "Inquiries" to "Inquiries 2026" and added a new empty tab called "Inquiries 2027". - Wednesday: marketing made the Email field on the website form optional, "so the form feels shorter". FAILED RUN 1 - Tuesday 9:14 AM Step 1 Trigger OK (Name: Laura Nilsson, Email: laura.nilsson@example.com, Group size: 14, Dates: May 8-10) Step 2 Google Sheets FAILED Error: Unable to parse range: Inquiries!A:F Step 3 AI step did not run Step 4 Gmail did not run FAILED RUN 2 - Tuesday 2:40 PM Same as run 1. Guest: Peter Adeyemi, group of 9, June 19-21. Error: Unable to parse range: Inquiries!A:F FAILED RUN 3 - Wednesday 11:05 AM Same error. Guest: Hye-jin Park, group of 20, September 4-6. FAILED RUN 4 - Thursday 4:22 PM Step 1 Trigger OK (Name: Tomas Ferreira, Email: [empty], Group size: 11, Dates: July 17-19) Step 2 Google Sheets FAILED Error: Unable to parse range: Inquiries!A:F Step 3 AI step did not run Step 4 Gmail did not run WHAT WE TRIED On Thursday evening the front desk manager opened Step 2 and pointed it at the tab "Inquiries 2027" by choosing it from the list. Then she pressed "Run once" with Tomas Ferreira's inquiry: Step 1 Trigger OK (Name: Tomas Ferreira, Email: [empty], Group size: 11, Dates: July 17-19) Step 2 Google Sheets OK (1 row added) Step 3 AI step OK Step 4 Gmail FAILED Error: Invalid To header So now it fails in a different place and she does not know if she made it better or worse. WHAT WE NEED Four groups have had no reply, the oldest for three days. A group booking is worth $4,000 to $9,000 to us.