Export Yandex Market Analytics to Google Sheets with n8n

Export Yandex Market “Shows & Sales” Analytics to Google Sheets—Automatically with n8n

This 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.

What this workflow does

• Scheduled or manual execution: Runs daily at 08:00 (or you can start it manually) and applies configurable report settings.
• Requests report generation from Yandex Market Partner API: The workflow fetches campaigns, then requests a “shows-sales” report grouped by offers for the configured date range.
• Waits and polls for completion: It waits for the estimated generation time (with a fallback delay), then repeatedly checks report status until it is DONE or the retry limit is reached.
• Downloads and parses results: The finished report archive is downloaded, decompressed, and the JSON rows are converted into individual n8n items.
• Loads data into Google Sheets: The workflow clears the target worksheet (keeping the header row) and appends all report rows as new entries.

Use cases

• Track Yandex Market performance (shows vs. sales by offer) without manual exports.
• Keep a SaaS operator’s reporting sheet up to date with automated daily analytics.
• Support internal dashboards by storing fresh report data directly in Google Sheets.

Technical details

• Integrations: Yandex Market Partner API (via HTTP Header Auth with OAuth token) and Google Sheets (Service Account).
• n8n nodes/components: if, code, wait, merge, compression, plus sticky note for workflow clarity.
• Configuration: Set $vars.GOOGLE_SHEET_ID and $vars.GOOGLE_SHEET_GID, and tune config_date_range_days, config_max_retries, and config_retry_delay_sec.