Kanaka Kishore Kandregula This workflow corresponds to n8n.io template #6783 — 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "9fab883b-4e0d-4a0c-bdd7-645bdcf2bc64",
"name": "Create Google Contact",
"type": "n8n-nodes-base.googleContacts",
"position": [
420,
960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "01a90ff9-45c4-4e4e-b70e-2a7c4b579ee2",
"name": "Split Customers",
"type": "n8n-nodes-base.splitOut",
"position": [
-20,
960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ac435ff1-821b-4212-a5ca-9b766c763508",
"name": "Log Synced Email",
"type": "n8n-nodes-base.googleSheets",
"position": [
420,
760
],
"parameters": {},
"typeVersion": 3
},
{
"id": "7ae863b1-386e-4b24-b033-4d5c1b083a19",
"name": "Compare Datasets",
"type": "n8n-nodes-base.compareDatasets",
"position": [
200,
840
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "4a18f856-216f-466a-aa91-ed016b3e9785",
"name": "GET PREVIOUS DATE",
"type": "n8n-nodes-base.code",
"position": [
-460,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2
},
{
"id": "09386b6e-0658-4875-9093-c8b74b971074",
"name": "Get New Customers",
"type": "n8n-nodes-base.httpRequest",
"position": [
-240,
960
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "de076cab-43e3-4b31-97e6-d80a8aa64ac4",
"name": "Get Existing Emails",
"type": "n8n-nodes-base.googleSheets",
"position": [
-20,
760
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "853608e4-1ba2-4673-82c8-7bd0436c9373",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
620
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "22564aa5-ed78-426e-9d67-e4b418eb5d58",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-760,
620
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "583ab4b6-c08d-436d-9e3d-92f006ee27e4",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-680,
800
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "28e76d85-dbad-4e30-aa29-06b9dff6d6b9",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-760,
440
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"Split Customers": {
"main": [
[
{
"node": "Compare Datasets",
"type": "main",
"index": 1
}
]
]
},
"Compare Datasets": {
"main": [
[],
[],
[],
[
{
"node": "Create Google Contact",
"type": "main",
"index": 0
},
{
"node": "Log Synced Email",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Existing Emails",
"type": "main",
"index": 0
},
{
"node": "GET PREVIOUS DATE",
"type": "main",
"index": 0
}
]
]
},
"GET PREVIOUS DATE": {
"main": [
[
{
"node": "Get New Customers",
"type": "main",
"index": 0
}
]
]
},
"Get New Customers": {
"main": [
[
{
"node": "Split Customers",
"type": "main",
"index": 0
}
]
]
},
"Get Existing Emails": {
"main": [
[
{
"node": "Compare Datasets",
"type": "main",
"index": 0
}
]
]
},
"Create Google Contact": {
"main": [
[]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow is a plug-and-play customer contact automation system designed for Magento 2 store owners, marketers, and CRM teams. It fetches customer records registered within the last 24 hours (from 00:00:00 to 23:59:59), checks against an existing Google Sheet to avoid…
Source: https://n8n.io/workflows/6783/ — 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.
Linkedin Workflow. Uses httpRequest, googleSheets. Scheduled trigger; 39 nodes.
BSW Growth Agent · Lite (Free Tier). Uses googleSheets, googleDrive, httpRequest, gmail. Scheduled trigger; 21 nodes.
Founder's Discovery Engine. Uses googleSheets, googleDrive, httpRequest, gmail. Scheduled trigger; 21 nodes.
R25 | The Ultimate Publishing Agent. Uses scheduleTrigger, googleSheets, httpRequest, stickyNote. Scheduled trigger; 15 nodes.
Perfect for store owners and agencies.