Google Sheets + Airtable: competitor lists that stay fresh
Your competitor list starts out neat. Then reality hits. New players pop up, brands re-position, and suddenly your “competitive landscape” doc is stale and a little embarrassing.
This is the kind of mess marketing managers feel every time they prep a launch brief. Agency strategists run into it when a client asks, “Who are we really up against?” And founders notice it when pricing pages stop converting. A solid competitor list automation keeps that list current without turning it into a weekly research chore.
This guide walks you through an n8n workflow that pulls company names from Google Sheets, finds competitors using SerpAPI, and logs clean results into Airtable (with sources). You’ll see what it automates, what outcomes to expect, and how to avoid the common gotchas.
How This Automation Works
Here’s the complete workflow you’ll be setting up:
n8n Workflow Template: Google Sheets + Airtable: competitor lists that stay fresh
flowchart LR
subgraph sg0["🕒 Auto Run (Scheduled) Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "🕒 Auto Run (Scheduled)", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "📄 Read Companies Sheet", pos: "b", h: 48 }
n2["<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/code.svg' width='40' height='40' /></div><br/>🧹 Clean & Format Company List"]
n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "🔁 Loop Over Companies", pos: "b", h: 48 }
n4["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>🌍 Search Company Competitors.."]
n5["<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/code.svg' width='40' height='40' /></div><br/>🧠 Extract Competitor Data fr.."]
n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "🧐 Has Competitors?", pos: "b", h: 48 }
n7@{ icon: "mdi:database", form: "rounded", label: "📊 Log to Result Sheet", pos: "b", h: 48 }
n8@{ icon: "mdi:database", form: "rounded", label: "❌ Log Companies Without Resu..", pos: "b", h: 48 }
n9["<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/airtable.svg' width='40' height='40' /></div><br/>🗃️ Sync to Airtable"]
n6 --> n7
n6 --> n8
n7 --> n9
n3 --> n4
n1 --> n2
n0 --> n1
n2 --> n3
n8 --> n9
n5 --> n6
n4 --> n5
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 n6 decision
class n1,n7,n8,n9 database
class n4 api
class n2,n5 code
classDef customIcon fill:none,stroke:none
class n2,n4,n5,n9 customIcon
Why This Matters: Competitor Lists Go Stale Fast
Competitor research is one of those tasks that looks simple until you do it at scale. One company is easy. Twenty is a time sink. And if you’re managing multiple products or clients, you end up repeating the same Google searches, copying names into a sheet, and trying to remember where you found each result. A month later, half the market has shifted. The worst part is the mental load: you’re never sure if you missed someone obvious or if your sources are even credible.
It adds up fast. Here’s where it breaks down in real teams.
- You spend about 10 minutes per company just doing “{brand} competitors” searches and opening tabs.
- Names get copied inconsistently, which means duplicates, spelling drift, and “is this the same company?” debates later.
- Sources are often missing, so you can’t defend the list when a stakeholder challenges it.
- When no competitors show up, that fact rarely gets tracked, so you re-check the same companies again next week.
What You’ll Build: A Daily Competitor Research Pipeline
This workflow turns a plain Google Sheet into a competitor discovery engine. Every day on a schedule (think 9 AM), n8n pulls your company list from Google Sheets, cleans it up, and then processes each company one-by-one so you don’t overload anything. For each entry, it sends a search request to SerpAPI for “{Company} competitors,” receives structured results, and extracts up to 10 competitor names plus a top source link you can click later. Then it writes the outcome back to a results sheet in Google Sheets and pushes the same record into Airtable so your team has a clean, filterable database. Companies with no results don’t get ignored; they’re logged into a separate “no competitors found” list for tracking.
The workflow starts with a scheduled trigger and a read from Google Sheets. SerpAPI does the heavy lifting for discovery, while n8n cleans, parses, and validates the results. Finally, Google Sheets and Airtable get updated so you can review quickly or build dashboards.
What You’re Building
| What Gets Automated | What You’ll Achieve |
|---|---|
|
|
Expected Results
Say you track 50 companies. Manually, if you spend about 10 minutes searching and capturing competitor names per company, that’s roughly 8 hours of work (and it’s never one clean block of time). With this workflow, you add companies to Google Sheets once, then the daily run does the searching and logging for you. Your “work” becomes a quick review in Airtable and the results sheet, maybe 15 minutes a day if you want to sanity-check new entries.
Before You Start
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for your company input list.
- Airtable to store and filter competitor records.
- SerpAPI API key (get it from your SerpAPI dashboard)
Skill level: Beginner. You’ll mostly connect accounts, paste an API key, and map a few fields.
Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).
Step by Step
A scheduled daily run kicks things off. n8n triggers at your chosen time (many teams pick a morning run), then immediately pulls the latest list of companies from your Google Sheet.
Your company list gets cleaned before anything else happens. Empty rows are removed, names are trimmed, and each row is tagged with a row number so results stay traceable when you review later.
SerpAPI searches competitors one company at a time. n8n loops through the list in batches, sends “{Company} competitors” as the query, and receives structured search data. Then it parses out the core items you care about: up to 10 competitor names, a source URL, and a count of results.
Results land in two places you already use. If competitors exist, the workflow appends them to a results Google Sheet. If not, it logs the company into a “missing competitors” section so you can follow up. Either way, Airtable is updated so you have one place to filter, tag, and compare across time.
You can easily modify the schedule and the number of competitors captured based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Schedule Trigger
Set the workflow to run automatically each day so competitor research starts without manual input.
- Add the 🕒 Scheduled Auto Trigger node as the workflow trigger.
- Set the schedule rule to run daily at
9for Trigger At Hour. - Connect 🕒 Scheduled Auto Trigger to 📄 Fetch Company Sheet.
Tip: Align the trigger time with your reporting window to avoid API rate-limit spikes.
Step 2: Connect Google Sheets
Configure the Google Sheets nodes that supply company inputs and capture competitor results.
- Open 📄 Fetch Company Sheet and select the spreadsheet with Document
[YOUR_ID]and Sheetgid=0. - Credential Required: Connect your googleSheetsOAuth2Api credentials in 📄 Fetch Company Sheet.
- Open 📊 Append to Results Sheet and confirm Operation is
appendOrUpdatewith matching on Company. - Map columns to values in 📊 Append to Results Sheet: Source
={{ $json.top_source }}, Company={{ $json.company }}, Competitors={{ $json.competitors }}, Total Results={{ $json.total_results }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials in 📊 Append to Results Sheet and ❌ Record Missing Competitors.
- In ❌ Record Missing Competitors, keep Operation as
appendOrUpdateand set fixed values: SourceNull, CompetitorsNo Competetitors Found, Total Results0, Company={{ $json.company }}.
⚠️ Common Pitfall: Make sure the input sheet column is named List—the next step depends on that exact key.
Step 3: Set Up Processing and Batching
Normalize the input companies and process them in batches to control API usage.
- In 🧹 Normalize Company Entries, keep the provided JavaScript that reads company names from
item.json.Listand returns{ company, row }. - Connect 📄 Fetch Company Sheet to 🧹 Normalize Company Entries, then to 🔁 Iterate Company Batch.
- Set Batch Size to
100in 🔁 Iterate Company Batch. - Connect the output of 🔁 Iterate Company Batch to 🌍 Competitor Search Request.
Step 4: Configure Search and Parsing
Call SerpAPI for competitor results and parse the response into a structured format.
- In 🌍 Competitor Search Request, set URL to
https://serpapi.com/search.jsonand keep Send Query enabled. - Set query parameters in 🌍 Competitor Search Request: q
={{ $json.company }} competitors, hlen, glus, api_key[CONFIGURE_YOUR_API_KEY]. - Connect 🌍 Competitor Search Request to 🧠 Parse Competitor Results and keep the provided parsing code intact.
⚠️ Common Pitfall: Replace [CONFIGURE_YOUR_API_KEY] or requests will fail with authorization errors.
Step 5: Configure Routing and Outputs
Route results based on competitor availability and ensure both paths are recorded.
- In 🧐 Competitor Presence Check, set the condition to compare
={{ $json.competitors }}notEqualsNo competitors found. - Connect 🧠 Parse Competitor Results to 🧐 Competitor Presence Check.
- Route the true output to 📊 Append to Results Sheet and the false output to ❌ Record Missing Competitors.
- Confirm that 📊 Append to Results Sheet then flows to 🗃️ Update Airtable Records, and ❌ Record Missing Competitors also flows to 🗃️ Update Airtable Records.
Step 6: Configure Airtable Upsert
Upsert final competitor results into Airtable for reporting and tracking.
- In 🗃️ Update Airtable Records, set Operation to
upsertand match on Company. - Map fields: Source
={{ $json.Source }}, Company={{ $json.Company }}, Competitors={{ $json.Competitors }}, Total Results={{ $json["Total Results"] }}. - Credential Required: Connect your airtableTokenApi credentials in 🗃️ Update Airtable Records.
Step 7: Test and Activate Your Workflow
Validate the full data path from Google Sheets to Airtable before enabling scheduled runs.
- Click Execute Workflow and confirm 📄 Fetch Company Sheet returns items with a
Listfield. - Verify 🌍 Competitor Search Request returns JSON and 🧠 Parse Competitor Results outputs
company,competitors, andtop_source. - Check that records are appended in 📊 Append to Results Sheet or ❌ Record Missing Competitors, and that 🗃️ Update Airtable Records performs an upsert.
- Once successful, switch the workflow status to Active to enable the daily schedule.
Troubleshooting Tips
- Google Sheets credentials can expire or need specific permissions. If things break, check the connected Google account in n8n’s Credentials section first, then confirm the sheet is shared correctly.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- SerpAPI can return different structures depending on the query and region. If parsing fails, inspect the HTTP Request node output and adjust the “Parse Competitor Results” code to match what you’re receiving.
Quick Answers
About 30 minutes if your accounts and sheets are ready.
No. You’ll connect Google Sheets, Airtable, and SerpAPI, then confirm the field mappings.
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 SerpAPI usage, which depends on your plan and how many searches you run daily.
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 it’s pretty straightforward. You can change the scheduled trigger to run weekly, or switch the Google Sheets input to a different spreadsheet without touching the rest. Want more or fewer competitors per company? Adjust the logic in the “Parse Competitor Results” step where it caps the list at 10. You can also redirect outputs by swapping the Airtable update step for a CRM update (HubSpot is commonly used) if you want competitors attached to accounts.
Usually it’s an API token or base permission issue. Reconnect the Airtable credential in n8n, then confirm the token has access to the right base and table. If the workflow used to work and suddenly doesn’t, check if the table fields were renamed because n8n will still try to write to the old field names.
Hundreds of companies per day is realistic, as long as your SerpAPI plan and n8n execution limits support that load.
Often, yes, because this workflow benefits from batching, branching, and custom parsing. n8n makes it easier to loop through a long list of companies and handle “no results” cleanly without building a mess of separate Zaps or scenarios. It’s also more flexible when you need to transform data before saving it (which you do here). That said, Zapier or Make can be fine for a tiny list and a simple “search then log” flow. Talk to an automation expert if you want a quick recommendation based on your volume.
Once this is running, your competitor list updates itself while you’re doing real work. Honestly, that’s the point: fewer tabs, fewer doubts, and a research system you can trust.
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.
