Score project inquiries and log them in a sheet
At a glance
The author uses Claude and Zapier to score Google Form inquiries from a consulting intake form alongside their original details in Google Sheets. This workflow is listed under Sales, Forms, Automation.
- Agents / tools
- Google Forms, Claude, Google Sheets, Zapier
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Create a Google Form for project inquiries with name, email, company, project description, budget range and desired start date. Submit a sample. Create a Google Sheet with corresponding headers and an AI score column. Prepare a funded Anthropic API account, connect it to Zapier and use a plan that supports the premium Claude app. 2) In a Zap choose Google Forms / New Form Response, connect the account, select the form and test with the sample. 3) Add Anthropic Claude / Send Message. In User Message, describe your business and scoring criteria, request a 0–100 fit score, and map the six form fields into the prompt. Select a model and test; adjust the scoring instructions if the result is unsuitable. 4) Add Google Sheets / Create Spreadsheet Row, connect Google and select the drive, spreadsheet and worksheet. Map each original answer to its column and Claude’s response to the AI column. Test, inspect the new row, then name and publish the Zap.
How it went
The tutorial shows a test score of 98 and a populated spreadsheet row for its sample inquiry.
Worth knowing
The tutorial uses Anthropic API credit and identifies Claude as a premium Zapier app. A score reflects the criteria supplied in the prompt.