Recover and triage repair quote emails with Gmail, OpenAI, and Google Sheets

## recover missed quote requests from the shop inbox with AI ### How it works 1. A Gmail trigger watches the shop inbox for new unread emails that look like service requests (quote, estimate, repair or service in the subject). 2. An AI assistant reads each email and decides if it is a real repair or quote request, then pulls out the vehicle (year, make, model) and the concern. It also checks whether the request has enough detail to price. 3. Requests with full detail are logged to Google Sheets and the shop owner gets an email with a one line summary, so the quote can go out the same day. 4. Requests that are missing vehicle details get an automatic reply asking for exactly what is missing, and are logged as waiting. 5. Emails that are not repair requests are skipped. 6. Every morning a sweep emails the owner the list of quote requests that are still open, so nothing is left to rot in the inbox. ### Setup steps - Connect a Gmail account for the inbox you want to watch and for the replies. - Set the shop owner email in the Notify and sweep steps. - Connect a Google Sheets account and set the spreadsheet with a Quotes tab. - Add an AI credential for the two assistants. - Adjust the Gmail search query in the trigger if you use a dedicated quote inbox. ### Customization - Change the trigger search query to match your own subject wording or a Gmail label. - Change the daily sweep hour and the number of days before a request counts as open. - Adjust the tone of the reply and the summary in the system prompts.