Argorant
n8n templateEnergy

Reach facilities before energy contracts end from Google Sheets with Argorant

Every Monday this workflow reads your facilities from a Google Sheet, picks sites whose energy contract ends in 6 to 9 months, checks that your contact still works there, finds the energy lead if not, and adds the right person to your Argorant contract end campaign.

Starts on
Schedule
Works with
Google Sheets
Workflow
12 nodes
Setup
4 steps

Who it is for

Commercial energy brokers and suppliers who know when a facility's contract ends but reach out after the incumbent has already offered a renewal.

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 Monday Schedule FiresTrigger · Schedule
  2. Read Facility ProspectsGoogle Sheets
  3. Check Contact Still WorksArgorant
  4. Find Energy Decision MakerArgorant
  5. Add to Contract End CampaignArgorant
  6. Write 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

  1. 1When Monday Schedule Fires starts the run. Read Facility Prospects reads company, domain, contract end (a date or a month name), site and contact.
  2. 2Keep Sites in Review Window keeps rows 180 to 270 days before the contract end that were not contacted for it.
  3. 3Check Contact Still Works checks the contact. If it no longer works, Find Energy Decision Maker looks for a facilities, energy or operations lead.
  4. 4Add to Contract End Campaign adds the person with contract_end and site.
  5. 5Write Status to Sheet marks the row as contacted for this contract, or for a manual look, so nobody is contacted twice for the same contract.
What you need

The tools this template connects.

Requirements

  • An Argorant account and an API key
  • A Google Sheet with your facilities and contract end 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.

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 the Argorant steps.
  2. 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.
  3. 3Create a contract end campaign in Argorant, use {{contract_end}} and {{site}} in the copy, and put its ID in the Settings step as campaign_id.
  4. 4Adjust the window and the titles in Settings, then activate the workflow.

Make it yours

  • Send a second campaign 90 days before the end to sites that did not reply
  • Add the CFO as a second contact for multi-site companies
  • Read contract ends from your CRM instead of a sheet

Nodes in this workflow

12 nodes

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

  1. When Monday Schedule FiresSchedule Trigger
  2. SettingsEdit Fields (Set)
  3. Read Facility ProspectsGoogle Sheets
  4. Keep Sites in Review WindowCode
  5. Check Anyone Is DueIf
  6. Stop When Nobody Is DueNo Operation
  7. Check Contact Still WorksArgorant (Email: Check)
  8. Route by Contact StatusIf
  9. Find Energy Decision MakerArgorant (Lead: Reveal)
  10. Check Decision Maker FoundIf
  11. Add to Contract End CampaignArgorant (Campaign: Add Leads)
  12. Write Status to SheetGoogle Sheets

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