Skip to content
UsecaseBoard
← All use cases
ZapierSales

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.

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.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →