Rahul Joshi This workflow corresponds to n8n.io template #8951 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "kxb2ryCoMzkhmn1Q",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "CRM Deal Stage Update",
"tags": [],
"nodes": [
{
"id": "e3e73b68-7446-46bc-a841-f57e5c21021d",
"name": "\u23f0 Daily Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
96,
896
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1
},
{
"id": "6d75184f-e2b1-43d1-9212-def76a8f144c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-352,
784
],
"parameters": {
"width": 398,
"height": 464,
"content": "## \ud83d\ude80 Automation Start\n\n**Purpose:** This automation runs on a schedule to sync paid Stripe invoices with your CRM system.\n\n**What it does:**\n1. Fetches all paid invoices from Stripe\n2. Looks up customer details in Google Sheets\n3. Updates deal status to \"Closed\" for paid customers\n4. Syncs back to your CRM tracking sheet\n\n**\ud83d\udca1 Tip:** Adjust the schedule interval based on how often you want to sync data."
},
"typeVersion": 1
},
{
"id": "48817707-e147-4d4c-ad97-4f1a1c4a3234",
"name": "\ud83d\udd0d Find Customer in CRM Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
816,
896
],
"parameters": {
"range": "A:C",
"options": {},
"sheetId": "1i0_YOUR_AWS_SECRET_KEY_HERE",
"operation": "lookup",
"lookupValue": "={{ $json.data.customer_email }}",
"lookupColumn": "Stripe Email",
"authentication": "oAuth2"
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "a82686ae-13cd-41bc-a862-de5644646cc2",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
512
],
"parameters": {
"width": 358,
"height": 364,
"content": "## \ud83d\udd0d Customer Lookup\n\n**What happens here:**\n- Takes each paid invoice email\n- Searches for matching customer in Google Sheets\n- Returns CRM details like HubSpot/Pipedrive Deal IDs\n\n**Sheet Structure Expected:**\n- Column A: Stripe Email\n- Column B: HubSpot Deal ID \n- Column C: Pipedrive Deal ID\n\n**\u26a0\ufe0f Important:** Make sure your sheet has these exact column headers!"
},
"typeVersion": 1
},
{
"id": "d66985e5-229b-4a76-a60e-1a2098d0a5da",
"name": "\ud83d\udcb3 Get Paid Invoices from Stripe",
"type": "n8n-nodes-base.httpRequest",
"position": [
336,
896
],
"parameters": {
"url": "https://api.stripe.com/v1/invoices",
"options": {},
"sendQuery": true,
"authentication": "predefinedCredentialType",
"queryParameters": {
"parameters": [
{
"name": "status",
"value": "paid"
}
]
},
"nodeCredentialType": "stripeApi"
},
"credentials": {
"stripeApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "7ffbdab4-3601-40b9-8db2-93d5f802b0ae",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
544
],
"parameters": {
"width": 318,
"height": 320,
"content": "## \ud83d\udcb3 Stripe API Call\n\n**Purpose:** Fetches all invoices with \"paid\" status from Stripe\n\n**API Endpoint:** /v1/invoices?status=paid\n\n**Returns:** List of paid invoices with customer details\n\n**\ud83d\udd27 Setup Required:**\n- Add your Stripe API credentials\n- Ensure API key has read permissions for invoices"
},
"typeVersion": 1
},
{
"id": "5f726010-2a52-4034-9aaf-8c2a788feb93",
"name": "\ud83d\udccb Split Invoice List",
"type": "n8n-nodes-base.splitOut",
"position": [
576,
896
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "data"
},
"typeVersion": 1
},
{
"id": "6a606041-a880-46aa-89b9-a739c5ec052e",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
1088
],
"parameters": {
"width": 288,
"height": 296,
"content": "## \ud83d\udccb Split Array Data\n\n**Purpose:** Converts the array of invoices into individual items\n\n**Why needed:** Stripe returns invoices as an array in the 'data' field. This node separates each invoice so we can process them individually.\n\n**Result:** Each paid invoice becomes a separate workflow item that can be processed in the next steps."
},
"typeVersion": 1
},
{
"id": "d7b8f723-5935-40a9-9e66-ca6b274ddff8",
"name": "\ud83e\uddf9 Clean Data & Mark as Closed",
"type": "n8n-nodes-base.code",
"position": [
1024,
896
],
"parameters": {
"jsCode": "return items\n .filter((item, index, self) => {\n return (\n Object.keys(item.json).length > 0 &&\n index === self.findIndex(t => t.json[\"Stripe Email\"] === item.json[\"Stripe Email\"])\n );\n })\n .map(item => {\n return {\n json: {\n ...item.json,\n Deal: \"Closed\"\n }\n };\n });\n"
},
"typeVersion": 2
},
{
"id": "ef040dd8-67d2-4bfb-82aa-7d30289e3682",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
1104
],
"parameters": {
"width": 358,
"height": 424,
"content": "## \ud83e\uddf9 Data Processing Logic\n\n**What this code does:**\n1. **Removes duplicates** - If same email appears multiple times, keeps only one\n2. **Filters empty records** - Removes any items without data\n3. **Sets deal status** - Adds 'Deal: Closed' to each record\n\n**Why needed:** \n- Prevents duplicate updates in your CRM\n- Ensures only valid records are processed\n- Automatically marks deals as won/closed since payment was received\n\n**\ud83d\udca1 Customization:** Change 'Closed' to match your CRM's deal stage naming (e.g., 'Won', 'Closed-Won', etc.)"
},
"typeVersion": 1
},
{
"id": "c7bd8e45-0fd1-4d66-9ce6-25a9a858b267",
"name": "\u2705 Update CRM Sheet with Closed Deals",
"type": "n8n-nodes-base.googleSheets",
"position": [
1232,
896
],
"parameters": {
"columns": {
"value": {
"Deal": "={{ $json.Deal }}",
"Stripe Email": "={{ $json[\"Stripe Email\"] }}",
"HubSpot Deal ID": "={{ $json[\"HubSpot Deal ID\"] }}",
"Pipedrive Deal ID": "={{ $json[\"Pipedrive Deal ID\"] }}"
},
"schema": [
{
"id": "Stripe Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Stripe Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HubSpot Deal ID",
"type": "string",
"display": true,
"required": false,
"displayName": "HubSpot Deal ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pipedrive Deal ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Pipedrive Deal ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Deal",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Deal",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Stripe Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1552459854,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1i0_YOUR_AWS_SECRET_KEY_HERE/edit#gid=1552459854",
"cachedResultName": "CRM"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1i0_YOUR_AWS_SECRET_KEY_HERE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1i0_YOUR_AWS_SECRET_KEY_HERE/edit?usp=drivesdk",
"cachedResultName": "Stripe Invoice store"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "59518fac-7bf3-4cad-9dc4-75dfe277b3e4",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1104,
448
],
"parameters": {
"width": 378,
"height": 424,
"content": "## \u2705 Final Update Step\n\n**Action:** Updates the Google Sheet with closed deal status\n\n**How it works:**\n- **Matches by:** Stripe Email (finds existing rows)\n- **Updates:** Deal status column to 'Closed'\n- **Preserves:** All existing CRM IDs and data\n\n**Column Mapping:**\n- Stripe Email \u2192 Stripe Email\n- HubSpot Deal ID \u2192 HubSpot Deal ID \n- Pipedrive Deal ID \u2192 Pipedrive Deal ID\n- Deal Status \u2192 Deal (set to 'Closed')\n\n**\ud83c\udfaf Result:** Your CRM tracking sheet now shows which deals are closed based on Stripe payments!"
},
"typeVersion": 1
},
{
"id": "8d610b5a-0db9-41e9-8380-2719f72e4572",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1552,
768
],
"parameters": {
"width": 398,
"height": 440,
"content": "## \ud83c\udfaf Automation Complete!\n\n**What was accomplished:**\n\u2705 Fetched all paid Stripe invoices\n\u2705 Found matching customers in your CRM sheet\n\u2705 Removed duplicates and cleaned data\n\u2705 Updated deal status to 'Closed'\n\u2705 Synced everything back to Google Sheets\n\n**Next Steps:**\n1. Set up your preferred schedule (daily, hourly, etc.)\n2. Test with a few sample records first\n3. Monitor the execution logs for any errors\n4. Customize deal status naming if needed\n\n**\ud83d\udd27 Troubleshooting:**\n- Check Stripe API credentials\n- Verify Google Sheets permissions\n- Ensure sheet column headers match exactly"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "72d572b1-bc10-442e-a0df-09a43c88cb7e",
"connections": {
"\u23f0 Daily Trigger": {
"main": [
[
{
"node": "\ud83d\udcb3 Get Paid Invoices from Stripe",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udccb Split Invoice List": {
"main": [
[
{
"node": "\ud83d\udd0d Find Customer in CRM Sheet",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udd0d Find Customer in CRM Sheet": {
"main": [
[
{
"node": "\ud83e\uddf9 Clean Data & Mark as Closed",
"type": "main",
"index": 0
}
]
]
},
"\ud83e\uddf9 Clean Data & Mark as Closed": {
"main": [
[
{
"node": "\u2705 Update CRM Sheet with Closed Deals",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udcb3 Get Paid Invoices from Stripe": {
"main": [
[
{
"node": "\ud83d\udccb Split Invoice List",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApistripeApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Keep your CRM always up to date by automatically syncing closed deals from Stripe into Google Sheets. This n8n workflow fetches all paid invoices, finds matching customer records in your CRM tracking sheet, removes duplicates, marks the deal as “Closed,” and updates the sheet in…
Source: https://n8n.io/workflows/8951/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
Google Sheets, HTTP Request, Form Trigger +2
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
Google Sheets, Google Sheets Tool, HTTP Request +1
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
Google Calendar, Google Sheets, HTTP Request +1
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Start, HTTP Request, Function Item +3
Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo
Email Send, HTTP Request, Google Sheets +1