


Reach insurance prospects before policy renewal from Google Sheets with Argorant
Every Monday this workflow reads your prospects from a Google Sheet, picks companies whose policy renews in 90 to 120 days, checks that your contact still works there, finds the CFO or owner if not, and adds the right person to your Argorant renewal campaign.
- Starts on
- Schedule
- Works with
- Google Sheets
- Workflow
- 12 nodes
- Setup
- 4 steps
Who it is for
Commercial insurance brokers who know when prospects' policies renew but reach out too late, after the incumbent broker has already started the review.
What happens, from trigger to result.
6 steps, read from the workflow's own nodes. The numbers match the steps under How it works.
- 1When Monday Schedule FiresTrigger · Schedule
1Read Insurance ProspectsGoogle Sheets
3Check Contact Still WorksArgorant
3Find CFO or OwnerArgorant
4Add to Renewal CampaignArgorant
5Write Status to SheetGoogle Sheets
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
- 1When Monday Schedule Fires starts the run. Read Insurance Prospects reads company, domain, renewal date or month, line of cover and contact.
- 2Keep Prospects in Review Window keeps rows 90 to 120 days before the next renewal that were not contacted for it.
- 3Check Contact Still Works checks the contact's address. If it no longer works, Find CFO or Owner looks for a decision maker at the company.
- 4Add to Renewal Campaign adds the person with renewal_date and line.
- 5Write Status to Sheet marks the row as contacted for this renewal, or for a manual look, so nobody is contacted twice for the same renewal.
The tools this template connects.

Google Sheetsworkspace.google.com
ArgorantYour API key from your account.
Requirements
- An Argorant account and an API key
- A Google Sheet with your prospects and renewal dates
- Community node n8n-nodes-argorant 0.3.1 or later
Credits
Checking a contact uses half an Argorant credit on average. Finding a new decision maker costs 1 credit when a person with a work email is found, nothing otherwise. Adding a person uses 1 credit if they join as new. No webhooks are needed; the workflow runs on a schedule.
Import it into n8n
- 1Create a new workflow, open the menu at the top right and choose Import from file.
- 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
- 1Install the community node n8n-nodes-argorant (Settings > Community nodes > Install) and add your Argorant API credential to the Argorant steps.
- 2Add a Google Sheets credential to both sheet steps and pick the sheet with the columns company, domain, renewal_date, line, contact_name, contact_email, status, contacted_for.
- 3Create a renewal campaign in Argorant, use {{renewal_date}} and {{line}} in the copy, and put its ID in the Settings step as campaign_id.
- 4Adjust the window and the decision maker titles in Settings, then activate the workflow.
Make it yours
- Run a second campaign 30 days later for prospects who did not reply
- Use a CRM view of prospects instead of the sheet
- Add the risk manager as a second contact for larger accounts
Nodes in this workflow
12 nodesEvery node in the workflow, in the order of the file.
- When Monday Schedule FiresSchedule Trigger
- SettingsEdit Fields (Set)
- Read Insurance ProspectsGoogle Sheets
- Keep Prospects in Review WindowCode
- Check Anyone Is DueIf
- Stop When Nobody Is DueNo Operation
- Check Contact Still WorksArgorant (Email: Check)
- Route by Contact StatusIf
- Find CFO or OwnerArgorant (Lead: Reveal)
- Check Decision Maker FoundIf
- Add to Renewal CampaignArgorant (Campaign: Add Leads)
- Write Status to SheetGoogle Sheets
More n8n templates

InsuranceNew companies arrive as a monthly file
On the first of each month you get a CSV by email with the owners and finance heads of newly founded companies.
- Starts on
- Schedule
- Workflow
- 7 nodes
- Setup
- 5 steps
- When Month Starts
Export New Company Owners
Download CSV File- +2more steps
IT servicesIT leaders on a given technology become a campaign
Name a technology in a form, and the IT leaders at companies that run it are saved and added to a campaign.
- Starts on
- Form
- Workflow
- 13 nodes
- Setup
- 5 steps
- When Market Form Is Sent
Count IT Leaders
Save Leaders as List- +5more steps
Law and taxLaw and accounting partners in a city join
Name a city in a form, and the partners of the firms there are saved as a list and added to your campaign.
- Starts on
- Form
- Workflow
- 12 nodes
- Setup
- 5 steps
- When City Form Is Sent
Count Firm Partners
Save Partners as List- +4more steps
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.
