Argorant
n8n templateWholesale

Find territory gaps from Google Sheets with Argorant counts and post them to Slack

Every quarter this workflow counts the buyer companies in each territory from your Google Sheet, works out the share of customers you already serve, ranks the biggest gaps, saves the buyers in the top gaps as Argorant lists and posts the ranking to Slack.

Starts on
Schedule
Works with
Google Sheets, Slack
Workflow
13 nodes
Setup
5 steps

Who it is for

Wholesale distributors and their sales managers who assign reps by territory and want to know where the untapped buyers are.

The flow

What happens, from trigger to result.

6 steps, read from the workflow's own nodes. The numbers match the steps under How it works.

  1. When Quarterly Schedule FiresTrigger · Schedule
  2. Read TerritoriesGoogle Sheets
  3. Count Buyer CompaniesArgorant
  4. Write Numbers to SheetGoogle Sheets
  5. Save Buyers in GapArgorant
  6. Post Gap Report to SlackSlack

A dot on the line is a logic node between two steps, such as a check, a filter or a field edit.

How it works

  1. 1When Quarterly Schedule Fires starts the run. Read Territories reads state, city and your customer count per row.
  2. 2Count Buyer Companies counts companies in your buyer industry in each territory for free.
  3. 3Rank Territory Gaps computes the share you serve and ranks territories under target_share_pct by unserved buyers.
  4. 4Write Numbers to Sheet fills buyers, share, rank and verdict in the sheet.
  5. 5Save Buyers in Gap saves the buyer titles in the top territories as lists, once per quarter, and Post Gap Report to Slack sends the ranking.
What you need

The tools this template connects.

Requirements

  • An Argorant account and an API key
  • A Google Sheet with your territories and customer counts
  • A Slack workspace
  • Community node n8n-nodes-argorant 0.3.1 or later

Credits

No Argorant credits are used. Counts and saved lists are free. No webhooks are needed; the workflow runs on a schedule.

Get the workflow file by email

Enter your work email and we send you the template. Then import it into n8n.

By requesting this template, you agree to our Terms and Privacy Policy and to emails from Argorant about templates and the product.

Import it into n8n

  1. 1Create a new workflow, open the menu at the top right and choose Import from file.
  2. 2Pick the downloaded file, add your credentials and follow the setup steps on this page.

No n8n yet? Get n8n. How the n8n integration works

Setup

  1. 1Install the community node n8n-nodes-argorant (Settings > Community nodes > Install) and add your Argorant API credential to both Argorant steps.
  2. 2Add a Google Sheets credential to both sheet steps and a Slack credential to Post Gap Report to Slack.
  3. 3Use the sheet columns state, city (optional), customers, buyers, share_pct, gap_rank, verdict and checked.
  4. 4In the Settings step, set your buyer industry, buyer titles, target share and how many top gaps get a list.
  5. 5Run it once by hand, check the sheet, then activate the workflow.

Make it yours

  • Count customers from your CRM instead of typing them into the sheet
  • Add each top gap list to a territory campaign for the rep who owns it
  • Count buyer people instead of companies when one buyer has many sites

Nodes in this workflow

13 nodes

Every node in the workflow, in the order of the file.

  1. When Quarterly Schedule FiresSchedule Trigger
  2. SettingsEdit Fields (Set)
  3. Read TerritoriesGoogle Sheets
  4. Split Sheet by TerritoryCode
  5. Check Territories to AnalyzeIf
  6. Stop When Sheet Is EmptyNo Operation
  7. Count Buyer CompaniesArgorant (Company: Count)
  8. Rank Territory GapsCode
  9. Write Numbers to SheetGoogle Sheets
  10. Keep Top Gaps OnlyFilter
  11. Skip Lists Built This QuarterRemove Duplicates
  12. Save Buyers in GapArgorant (List: Create)
  13. Post Gap Report to SlackSlack

You do not need a workflow tool to get started. Run your outreach directly in Argorant, or let your AI do everything through our MCP, from pulling leads and buying mailboxes to creating campaigns. A campaign is set up in 10 minutes.

Your campaign in minutes, in the app or from your AI.

Start your 7-day free trial.

Loved by revenue teams
“The appointments you're booking are crazy: Hugo Boss, AboutYou, Drykorn, Jack Wolfskin, all within a week.”
Christian Schmidt & Mike Klaßen, Co-Founders & Owners, Boldbrands · Germany