Workflow: automate with n8n workflow for Http Googlesheets Send Webhook
Integrations: gmail, googleSheets, httpRequest, moveBinaryData, set, spreadsheetFile, stickyNote, writeBinaryFile

{"nodes": [{"name": "HTTP Request", "type": "n8n-nodes-base.httpRequest", "position": [560, 700], "parameters": {"url": "https://randomuser.me/api/", "options": {}}, "typeVersion": 2}, {"name": "Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [960, 560], "parameters": {"range": "A:C", "options": {"usePathForKeyRow": true}, "sheetId": "qwertz", "operation": "append", "authentication": "oAuth2"}, "credentials": {"googleSheetsOAuth2Api": {"id": "2", "name": "google_sheets_oauth"}}, "typeVersion": 1}, {"name": "Set", "type": "n8n-nodes-base.set", "position": [760, 700], "parameters": {"values": {"string": [{"name": "name", "value": "={{$json[\"results\"][0][\"name\"][\"first\"]}} {{$json[\"results\"][0][\"name\"][\"last\"]}}"}, {"name": "country", "value": "={{$json[\"results\"][0][\"location\"][\"country\"]}}"}]}, "options": {}, "keepOnlySet": true}, "typeVersion": 1}, {"name": "Spreadsheet File", "type": "n8n-nodes-base.spreadsheetFile", "position": [960, 840], "parameters": {"options": {"fileName": "users_spreadsheet"}, "operation": "toFile", "fileFormat": "csv"}, "typeVersion": 1}, {"name": "Spreadsheet File1", "type": "n8n-nodes-base.spreadsheetFile", "position": [960, 1200], "parameters": {"options": {}}, "typeVersion": 1}, {"name": "Write Binary File", "type": "n8n-nodes-base.writeBinaryFile", "position": [1360, 1200], "parameters": {"fileName": "randomusers.json"}, "typeVersion": 1}, {"name": "Move Binary Data1", "type": "n8n-nodes-base.moveBinaryData", "position": [1160, 1200], "parameters": {"mode": "jsonToBinary", "options": {}}, "typeVersion": 1}, {"name": "Gmail1", "type": "n8n-nodes-base.gmail", "position": [1360, 1420], "parameters": {"message": "Hello, attached is a JSON file with random user information.", "subject": "JSON file with users", "additionalFields": {"attachmentsUi": {"attachmentsBinary": [{"property": "data"}]}}}, "credentials": {"gmailOAuth2": {"id": "16", "name": "gmail"}}, "typeVersion": 1}, {"name": "Google Sheets2", "type": "n8n-nodes-base.googleSheets", "notes": "Append data to sheet", "position": [1760, 1420], "parameters": {"range": "A:C", "options": {"usePathForKeyRow": true}, "sheetId": "qwertz", "operation": "append", "authentication": "oAuth2"}, "credentials": {"googleSheetsOAuth2Api": {"id": "2", "name": "google_sheets_oauth"}}, "notesInFlow": true, "typeVersion": 1}, {"name": "Move Binary Data2", "type": "n8n-nodes-base.moveBinaryData", "position": [1560, 1420], "parameters": {"options": {}, "sourceKey": "attachment_0"}, "typeVersion": 1}, {"name": "Note", "type": "n8n-nodes-base.stickyNote", "position": [1200, 560], "parameters": {"width": 320, "height": 80, "content": "## JSON > Google Sheets"}, "typeVersion": 1}, {"name": "Note1", "type": "n8n-nodes-base.stickyNote", "position": [1200, 860], "parameters": {"width": 320, "height": 80, "content": "## JSON > CSV"}, "typeVersion": 1}, {"name": "Note2", "type": "n8n-nodes-base.stickyNote", "position": [580, 1220], "parameters": {"width": 320, "height": 80, "content": "## CSV > JSON file"}, "typeVersion": 1}, {"name": "Note3", "type": "n8n-nodes-base.stickyNote", "position": [980, 1460], "parameters": {"width": 320, "height": 80, "content": "## JSON file > Google Sheets"}, "typeVersion": 1}], "connections": {"Set": {"main": [[{"node": "Google Sheets", "type": "main", "index": 0}, {"node": "Spreadsheet File", "type": "main", "index": 0}]]}, "Gmail1": {"main": [[{"node": "Move Binary Data2", "type": "main", "index": 0}]]}, "HTTP Request": {"main": [[{"node": "Set", "type": "main", "index": 0}]]}, "Spreadsheet File": {"main": [[{"node": "Spreadsheet File1", "type": "main", "index": 0}]]}, "Move Binary Data1": {"main": [[{"node": "Write Binary File", "type": "main", "index": 0}]]}, "Move Binary Data2": {"main": [[{"node": "Google Sheets2", "type": "main", "index": 0}]]}, "Spreadsheet File1": {"main": [[{"node": "Move Binary Data1", "type": "main", "index": 0}]]}, "Write Binary File": {"main": [[{"node": "Gmail1", "type": "main", "index": 0}]]}}}