New signups land in your Google Sheet and get scored in minutes. Leads are checked as they come in and a clear rating is written back to the sheet. Sales or community teams can sort entries fast and focus on the best contacts.

Here is how the build runs end to end. A Google Sheets trigger watches for new rows every minute. Each new row goes to OpenAI with a system prompt and a user message that passes the form fields. The reply is structured as JSON and parsed by a Set node into a reply object. A Merge node combines the original sheet data with the AI result by position. The Google Sheets node then updates the matching row by Timestamp and writes the rating into a dedicated column.

To put this in place you need Google Sheets access and an OpenAI API key. Map a stable match column such as Timestamp and create a Rating column to store the AI score. Expect faster triage, more consistent decisions, and less time spent reading long answers. Common uses include screening community join requests, workshop signups, or newsletter referrals where you need quick and fair sorting.

• Google Sheets trigger checks for new rows every minute and sends only fresh entries forward.
• OpenAI chat model scores each lead using a clear system prompt with a low temperature for consistent output.
• JSON parsing with the Set node converts the AI message content into a clean reply object.
• Merge by position combines the original form data with the AI result to keep fields aligned.
• Update action in Google Sheets matches on Timestamp and writes the rating back to a dedicated column.
• Editable prompts let you change rules for what makes a qualified lead without code.

• Reduce manual screening from 2 hours a day to 10 minutes
• Automate up to 90 percent of lead triage with consistent rules
• Improve data accuracy by writing ratings directly to the sheet
• Handle 5 to 10 times more form volume without extra staff
• Connect Google Sheets and OpenAI in one seamless flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet: include a Timestamp column from your form and add a Rating column where the score will be saved. Keep the sheet tab name stable.
4. Open the Google Sheets Trigger node. In the 'Credential to connect with' dropdown, click 'Create new credential' and follow the on screen steps to connect your Google account. Pick your document and the correct sheet tab. Keep the event set to rowAdded and the poll time to every minute.
5. Open the OpenAI node. In the credential dropdown, click 'Create new credential', paste your API key from the OpenAI API page, and save. Keep the model as gpt 4 turbo preview and temperature at 0.3.
6. Review the system and user messages in the OpenAI node. Confirm the form fields from the Google Sheet are passed in the user message so the model can score the lead.
7. Open the Set node named Extract JSON reply. Make sure it parses JSON with JSON.parse($json.message.content) into a field called reply. If your prompt returns plain text, adjust the parsing or change the prompt to return valid JSON.
8. Open the Merge node and confirm Mode is Combine and Combination Mode is Merge By Position. Ensure the top input is the trigger data and the bottom input is the AI reply path so items line up.
9. Open the Google Sheets node named Update lead status. Use the same document and sheet as the trigger. Set Column to Match On to Timestamp and map reply.rating to the Rating column.
10. Run a test by submitting a new form entry. Check the n8n execution log to confirm the OpenAI reply parses without errors and that the sheet row updates with a rating.
11. Troubleshoot common issues: if no update occurs, verify the Timestamp format in both nodes matches exactly. If JSON parsing fails, tighten the prompt and ensure the model returns a strict JSON object. Recheck credentials if authentication errors appear.
12. Name your credentials clearly, for example Company Google Sheets or Team OpenAI, so future edits are easy to manage.