{"product_id":"daily-jobspipe-jobs-to-google-sheets-n8n-workflow","title":"Daily JobsPipe Jobs to Google Sheets (n8n Workflow)","description":"\u003ch3\u003eAutomatically collect new JobsPipe jobs into Google Sheets—every day at 07:00\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow connects to \u003cstrong\u003eJobsPipe\u003c\/strong\u003e, searches for newly discovered job postings based on your filters, and then \u003cstrong\u003eappends or updates rows in Google Sheets keyed by job ID\u003c\/strong\u003e—so you keep a clean, non-duplicated job tracker without manual work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 07:00\u003c\/strong\u003e using a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003eDefines your search criteria, including \u003cstrong\u003ejob titles\u003c\/strong\u003e, \u003cstrong\u003ecountry codes\u003c\/strong\u003e, a \u003cstrong\u003elookback window\u003c\/strong\u003e, and \u003cstrong\u003epage size\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls the \u003cstrong\u003eJobsPipe \u003ccode\u003e\/v1\/jobs\/search\u003c\/code\u003e API\u003c\/strong\u003e to fetch jobs discovered within the lookback window.\u003c\/li\u003e\n  \u003cli\u003ePaginates through results using the \u003cstrong\u003ecursor\u003c\/strong\u003e returned by the API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits the response\u003c\/strong\u003e so each job posting is processed individually.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds or updates\u003c\/strong\u003e each job in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, matching on the job \u003cstrong\u003e\u003ccode\u003eid\u003c\/code\u003e\u003c\/strong\u003e to prevent duplicates across runs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a daily “new jobs” pipeline for specific roles by automatically syncing JobsPipe discoveries to a spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eTrack salary and posting details over time by keeping a single row per job ID in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS operations and research workflows where consistent, deduplicated data export to Google Sheets is required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eJobsPipe\u003c\/strong\u003e: Requires a JobsPipe API key (free tier available). The workflow uses an n8n Header Auth credential named \u003ccode\u003eJobsPipe API\u003c\/code\u003e with \u003ccode\u003eAuthorization: Bearer \u0026lt;your_key\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: Schedule Trigger, HTTP Request, Set, Split Out, Sticky Note, and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets mapping\u003c\/strong\u003e: Ensure your sheet includes headers at minimum: \u003ccode\u003eid\u003c\/code\u003e, \u003ccode\u003ejob_title\u003c\/code\u003e, \u003ccode\u003ecompany\u003c\/code\u003e, \u003ccode\u003elocation\u003c\/code\u003e, \u003ccode\u003eurl\u003c\/code\u003e, \u003ccode\u003edate_posted\u003c\/code\u003e, \u003ccode\u003esalary_string\u003c\/code\u003e, \u003ccode\u003emin_annual_salary\u003c\/code\u003e, \u003ccode\u003emax_annual_salary\u003c\/code\u003e, \u003ccode\u003esalary_currency\u003c\/code\u003e, and \u003ccode\u003ediscovered_at\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eWhat you need\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA JobsPipe API key (free tier works)\u003c\/li\u003e\n  \u003cli\u003eA Google account with access to Google Sheets\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114765209779,"sku":"N8N-19981","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/D6D0MUNwdPT8m2E1CqSjh_6wDopNKO.png?v=1790587502","url":"https:\/\/buyflowscripts.com\/products\/daily-jobspipe-jobs-to-google-sheets-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}