Jotform + Google Sheets, UGC creators shortlisted fast
UGC applications come in fast, then everything slows down. You open submissions, squint at rubrics, copy details into a sheet, and somehow the best creators end up waiting while your inbox fills up.
This hits influencer marketing managers first, but founders running lean and agency producers feel it too. With this Jotform Sheets automation, every applicant gets scored the same way, strong fits get shortlisted automatically, and your outreach goes out without you babysitting it.
Below you’ll see how the workflow runs, what results to expect, and what you’ll need to get it live.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Jotform + Google Sheets, UGC creators shortlisted fast
flowchart LR
subgraph sg0["JotForm Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/jotform.dark.svg' width='40' height='40' /></div><br/>JotForm Trigger"]
n1@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
n2@{ icon: "mdi:brain", form: "rounded", label: "Google Gemini Chat Model", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Append or update row in sheet", pos: "b", h: 48 }
n4@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
n5@{ icon: "mdi:message-outline", form: "rounded", label: "Send Candidate Shortlist Email", pos: "b", h: 48 }
n6@{ icon: "mdi:message-outline", form: "rounded", label: "Notify HR of Shortlist", pos: "b", h: 48 }
n4 --> n3
n1 --> n4
n0 --> n1
n2 -.-> n1
n3 --> n5
n3 --> n6
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n1 ai
class n2 aiModel
class n4 decision
class n3 database
classDef customIcon fill:none,stroke:none
class n0 customIcon
The Problem: UGC screening turns into inbox chaos
Screening UGC creators looks simple until you’re doing it at volume. A “quick review” becomes ten tabs open, a rubric you try to apply consistently, and a spreadsheet that’s always one column behind. You tell yourself you’ll email the best applicants first, but you still need to read everything to find them. Meanwhile, strong creators get snapped up by another brand because your response time is slow, not because your offer is bad. Honestly, this is where good campaigns lose momentum.
The friction compounds. Here’s where it breaks down in real life.
- You end up re-scoring the same applicant twice because notes live in DMs, email threads, and half-finished sheets.
- Rubrics drift over time, so “a 7” today isn’t “a 7” next week.
- Copy-pasting submission data into Google Sheets creates small errors that snowball later (wrong handle, wrong niche, wrong country).
- Outreach gets delayed because sending shortlist emails is a separate task you do “after screening,” which means it often happens tomorrow.
The Solution: AI scoring + automatic shortlisting in Sheets
This workflow turns each new Jotform submission into a scored, tracked, actioned candidate automatically. The moment a creator applies, n8n picks up the submission and sends the responses to an AI scoring agent (powered by Google Gemini in this workflow). That agent applies your rubric and returns a clean, definitive score from 0 to 10, so you’re not guessing or “vibe checking” applicants at 11pm. If the score meets your threshold (set to 6+ by default), the workflow writes the candidate record into Google Sheets and immediately sends two emails through Gmail: one to the creator (shortlist/next steps) and one to your internal HR or marketing team so follow-up is instant.
The workflow starts with a Jotform trigger. AI scores the candidate and an If check decides qualified or not. Qualified applicants get logged in Google Sheets, then Gmail outreach and an internal alert go out in parallel.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say your UGC form brings in 40 applicants a week. If you spend about 8 minutes reviewing, scoring, and logging each one, that’s roughly 5 hours of admin before you even send outreach. With this workflow, submitting is instant, scoring runs automatically, and Sheets + Gmail update in the background. You still review the shortlist, but now it’s maybe 10 strong candidates, not 40 “maybes.” That’s your Friday afternoon back.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Jotform to collect creator applications
- Google Sheets to store and shortlist candidates
- Gmail to send creator + internal emails
- Google Gemini API key (get it from Google AI Studio / Google Cloud credentials)
Skill level: Beginner. You will connect accounts, paste a few IDs, and edit the scoring prompt to match your rubric.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A creator submits your Jotform. The “Form Submission Hook” triggers instantly when someone completes the application.
The workflow turns answers into a score. An AI Agent sends the submission to Google Gemini with your rubric and returns a 0–10 performance score you can actually compare across applicants.
A qualification check keeps standards consistent. The If rule tests the score against your minimum (6+ by default). Low-scoring entries stop there, so your sheet doesn’t fill with noise.
Qualified creators get logged and contacted. The workflow writes the candidate data and final score into Google Sheets, then sends a shortlist email to the creator and a separate internal notification to your team via Gmail.
You can easily modify the score threshold to match different campaigns based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Form Submission Trigger
This workflow starts when a new Jotform submission is received.
- Add and open Form Submission Hook.
- Set Form to
YOUR_JOTFORM_ID_HERE. - Credential Required: Connect your
jotFormApicredentials.
Step 2: Connect Google Sheets
Candidate data and AI scores are appended or updated in your spreadsheet.
- Open Update Candidate Sheet and set Operation to
appendOrUpdate. - Set Spreadsheet to
[YOUR_ID]and Sheet toSheet1(gid0). - Ensure the column mappings use the provided expressions, for example AI Rate =
{{$json.output}}and Email ={{ $('Form Submission Hook').item.json.Email }}. - Credential Required: Connect your
googleSheetscredentials.
AI Rate, Candidate Name), the update will fail. Align headers exactly.Step 3: Set Up the AI Scoring Logic
The AI agent scores candidates and the workflow filters for a minimum score.
- Open Candidate Scoring Agent and confirm the Text prompt includes the candidate data expression
{{ JSON.stringify($json, null, 2) }}. - Open Gemini Chat Engine and set Model Name to
models/gemini-2.5-flash-lite. - Connect Gemini Chat Engine to Candidate Scoring Agent as the language model.
- Credential Required: Connect your
lmChatGoogleGeminicredentials in Gemini Chat Engine (AI sub-nodes use the parent credentials). - Open Score Threshold Check and verify the condition uses Left Value
{{ $json.output }}with Operationgteand Right Value6.
Step 4: Configure Output Emails and Parallel Alerts
Qualified candidates are saved, then two notifications are sent in parallel.
- Confirm Update Candidate Sheet connects to both Send Shortlist Notice and Alert HR Team in parallel.
- In Send Shortlist Notice, set Send To to
{{ $json.Email }}. - Credential Required: Connect your
gmailOAuth2credentials in Send Shortlist Notice. - In Alert HR Team, set Send To to
[YOUR_EMAIL]. - Credential Required: Connect your
gmailOAuth2credentials in Alert HR Team.
Step 5: Test and Activate Your Workflow
Validate the full flow before turning it on in production.
- Click Execute Workflow and submit a test form to Form Submission Hook.
- Confirm Candidate Scoring Agent returns a numeric score and Score Threshold Check routes accordingly.
- Verify a row is written in Update Candidate Sheet with AI Rate filled from
{{$json.output}}. - Check both emails from Send Shortlist Notice and Alert HR Team were delivered.
- Toggle the workflow to Active for production use.
Common Gotchas
- Jotform credentials can expire or need specific permissions. If things break, check the Jotform API settings and connected app access first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Gmail can silently fail if the connected account has restricted scopes or sending limits. Look at the n8n execution log for “insufficient permissions” and re-auth the Gmail connection.
Frequently Asked Questions
About 30 minutes if your accounts and form are ready.
No. You’ll mainly connect Jotform, Google Sheets, and Gmail, then paste in a few IDs.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Google Gemini API usage, which is usually a small per-request cost depending on your plan.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and you should. Update the rubric inside the “Candidate Scoring Agent” prompt so it matches your campaign (platform fit, niche, usage rights, turnaround time, whatever matters). You can also change the minimum pass score in “Score Threshold Check” from 6 to any number. Many teams add a “maybe” lane too, like logging 5–6 scores in Sheets without emailing them.
Usually it’s expired credentials or the wrong form ID in the Jotform Trigger. Regenerate the Jotform API key (or reconnect OAuth, depending on your setup) and update the n8n credential. Also confirm the account you connected can access that exact form, especially if it lives in a team workspace. If it works sometimes and fails at volume, check for API limits and slow down intake with batching.
A lot. On n8n Cloud, it depends on your monthly execution allowance, and self-hosting is mainly limited by your server. Practically, most teams run hundreds of submissions a week without issues as long as the AI provider and Gmail aren’t rate-limiting you.
Often, yes, for two reasons: the AI scoring + branching logic is easier to control in n8n, and you can self-host for unlimited runs. Zapier and Make are fine for basic “form → sheet” logging, but they can get pricey once you add filters, multi-email steps, and retries. n8n also makes it simpler to inspect a failed run and fix it without rebuilding the whole thing. If you want to ship this quickly and not worry about edge cases, get help for the first setup. Talk to an automation expert and you’ll know which route is best for your volume.
Once this is set up, shortlisting stops being a weekly fire drill. The workflow handles the repetitive screening work so you can focus on creative direction and closing the best creators fast.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
