{"product_id":"export-yandex-market-analytics-to-google-sheets-with-n8n","title":"Export Yandex Market Analytics to Google Sheets with n8n","description":"\u003ch3\u003eExport Yandex Market “Shows \u0026amp; Sales” Analytics to Google Sheets—Automatically with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow generates a Yandex Market “shows-sales” analytics report for your chosen date range, waits until it’s ready, downloads and parses the JSON data, then appends the results into a designated Google Sheets worksheet—on a schedule (daily at 08:00) or on demand.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled or manual execution:\u003c\/strong\u003e Runs daily at \u003cstrong\u003e08:00\u003c\/strong\u003e (or you can start it manually) and applies configurable report settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests report generation from Yandex Market Partner API:\u003c\/strong\u003e The workflow fetches campaigns, then requests a \u003cstrong\u003e“shows-sales” report grouped by offers\u003c\/strong\u003e for the configured date range.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits and polls for completion:\u003c\/strong\u003e It waits for the estimated generation time (with a fallback delay), then repeatedly checks report status until it is \u003cstrong\u003eDONE\u003c\/strong\u003e or the retry limit is reached.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and parses results:\u003c\/strong\u003e The finished report archive is downloaded, decompressed, and the \u003cstrong\u003eJSON rows\u003c\/strong\u003e are converted into individual n8n items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads data into Google Sheets:\u003c\/strong\u003e The workflow \u003cstrong\u003eclears the target worksheet (keeping the header row)\u003c\/strong\u003e and appends all report rows as new entries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack \u003cstrong\u003eYandex Market performance\u003c\/strong\u003e (shows vs. sales by offer) without manual exports.\u003c\/li\u003e\n  \u003cli\u003eKeep a SaaS operator’s reporting sheet up to date with automated daily analytics.\u003c\/li\u003e\n  \u003cli\u003eSupport internal dashboards by storing fresh report data directly in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Yandex Market Partner API (via HTTP Header Auth with OAuth token) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Service Account).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/components:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003ecompression\u003c\/code\u003e, plus \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow clarity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e Set \u003ccode\u003e$vars.GOOGLE_SHEET_ID\u003c\/code\u003e and \u003ccode\u003e$vars.GOOGLE_SHEET_GID\u003c\/code\u003e, and tune \u003ccode\u003econfig_date_range_days\u003c\/code\u003e, \u003ccode\u003econfig_max_retries\u003c\/code\u003e, and \u003ccode\u003econfig_retry_delay_sec\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916232122547,"sku":"N8N-18824","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ciHyyOfMlOLqFdLK5YL0_NwaF01gj.png?v=1788012829","url":"https:\/\/buyflowscripts.com\/products\/export-yandex-market-analytics-to-google-sheets-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}