Templates / Sync face-to-face fundraising data from offline Google Sheets to SinergiaCRM

Sync face-to-face fundraising data from offline Google Sheets to SinergiaCRM

Unknown

by Javier Quilez Cabello ✓ · 38 views · created 2025-09-18 · CRM

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This workflow has 13 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Sinergiacrm (community).

How it runs

Trigger: On Google Sheets events (row added).

  1. Check if Row Should Go to CRM (If): checks a condition and branches into true / false
  2. Check if Row Has Not Been Processed (If): checks a condition and branches into true / false
  3. Find Existing Contact in CRM by NIF (Sinergia Crm): uses Sinergia Crm
  4. Combinar ID del CRM (Merge): merges the data from its input branches
  5. Edit Fields (Edit Fields (Set)): sets 8 fields: First name, Last name, NIF…
  6. Check if Contact Already Exists in CRM (If): checks a condition and branches into true / false
  7. Create Member Relationship in SinergiaCRM (Sinergia Crm): create
  8. Create New Contact in SinergiaCRM (Sinergia Crm): create
  9. Sinergia Crm: create
  10. Create Member Relationship in SinergiaCRM (Sinergia Crm): create

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsSinergiacrm (community)

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

  • Check that n8n-nodes-sinergiacrm is verified or supports 3.0 (used in SinergiaCRM: Create Payment Commitment, Find Existing Contact in CRM by NIF, Create New Contact in SinergiaCRM).

Nodes used (6)

From the author

Automate syncing of offline donor data from Google Sheets into SinergiaCRM for fast, error-free face-to-face fundraising tracking. Who is this workflow for? This workflow is perfect for nonprofit organizations that run face-to-face fundraising campaigns and…

Excerpt from Javier Quilez Cabello's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.