Search Console Reporter

{"nodes":[{"id":"8e3f167d-cbeb-4f7f-a867-c356d2dca9d0","name":"Split Out","type":"n8n-nodes-base.splitOut","position":[1580,240],"parameters":{"options":{},"fieldToSplitOut":"rows"},"typeVersion":1},{"id":"19370d12-f6de-44a1-91a6-da097abdf7de","name":"Edit Fields","type":"n8n-nodes-base.set","position":[1780,240],"parameters":{"options":{},"assignments":{"assignments":[{"id":"7343c80f-37f3-4bb5-84d8-9f21f8a350cd","name":"Keyword","type":"string","value":"={{ $json.keys[0] }}"},{"id":"436e7c8b-2df2-40a9-97af-597dc00cf143","name":"clicks","type":"number","value":"={{ $json.clicks }}"},{"id":"5b4aaffe-391a-4c9d-8249-f447397a3f5d","name":"impressions","type":"number","value":"={{ $json.impressions }}"},{"id":"33677237-57fe-48f4-aff8-72ae81b5f5a2","name":"ctr","type":"number","value":"={{ $json.ctr }}"},{"id":"f961deee-d222-4df7-a7ff-b7286405e4a7","name":"position","type":"number","value":"={{ $json.position }}"}]}},"typeVersion":3.4},{"id":"d3bbf719-9524-4269-8c26-0eb7599add55","name":"Schedule Trigger","type":"n8n-nodes-base.scheduleTrigger","position":[700,460],"parameters":{"rule":{"interval":[{}]}},"typeVersion":1.2},{"id":"092645b2-9e75-4ff0-8d33-4a3acadac789","name":"Set your domain","type":"n8n-nodes-base.set","position":[980,460],"parameters":{"options":{},"assignments":{"assignments":[{"id":"6f74dee0-3789-433e-b60e-ed2a05202675","name":"domain","type":"string","value":"funautomations.io"},{"id":"8c73135e-9d39-4f66-821d-7decb3c64085","name":"days","type":"number","value":30}]}},"typeVersion":3.4},{"id":"0b04b552-e484-417b-9a7e-a90d477dd45a","name":"Get query Report","type":"n8n-nodes-base.httpRequest","position":[1360,240],"parameters":{"url":"=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query","method":"POST","options":{},"sendBody":true,"specifyBody":"json","authentication":"predefinedCredentialType","nodeCredentialType":"googleOAuth2Api"},"credentials":{"httpHeaderAuth":{"id":"credential-id","name":"httpHeaderAuth Credential"},"googleOAuth2Api":{"id":"credential-id","name":"googleOAuth2Api Credential"}},"typeVersion":4.2},{"id":"9f9f2be7-1301-4c91-8da1-86eab5725683","name":"Get Page Report","type":"n8n-nodes-base.httpRequest","position":[1360,440],"parameters":{"url":"=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query","method":"POST","options":{},"sendBody":true,"specifyBody":"json","authentication":"predefinedCredentialType","nodeCredentialType":"googleOAuth2Api"},"credentials":{"httpHeaderAuth":{"id":"credential-id","name":"httpHeaderAuth Credential"},"googleOAuth2Api":{"id":"credential-id","name":"googleOAuth2Api Credential"}},"typeVersion":4.2},{"id":"f8f62dde-1529-4d3a-a030-aa952496652d","name":"Update queries to Sheets","type":"n8n-nodes-base.googleSheets","position":[1980,240],"parameters":{"columns":{"value":{},"mappingMode":"autoMapInputData","matchingColumns":["Keyword"]},"options":{},"operation":"appendOrUpdate"},"credentials":{"googleSheetsOAuth2Api":{"id":"credential-id","name":"googleSheetsOAuth2Api Credential"}},"typeVersion":4.5}],"pinData":{},"connections":{"Split Out":{"main":[[{"node":"Edit Fields","type":"main","index":0}]]},"Set your domain":{"main":[[{"node":"Get query Report","type":"main","index":0},{"node":"Get Page Report","type":"main","index":0}]]},"Get query Report":{"main":[[{"node":"Split Out","type":"main","index":0}]]},"Schedule Trigger":{"main":[[{"node":"Set your domain","type":"main","index":0}]]}}}

JSON copied to clipboard!