export-ad-reports

name	export-ad-reports
description	Export advertising reports from Yandex Direct, Yandex Metrika, VK Ads, and Avito Ads through LidFly MCP v3 into connected Google Sheets, Google Docs, or Google Drive files, including verified tables and public creative images. Use when the user asks to export, save, append, or update advertising statistics in a Google file.

Export Ad Reports

Use this skill as the handoff between a provider skill, LidFly MCP v3 read calls, and Google connector write actions. Do not write the export to a Workspace unless the user separately asks for that.

Data Boundary

• Export aggregated statistics, spend, impressions, clicks, conversions, campaign/group/ad IDs, ad copy, and public creative URLs.
• Export a creative image only when its URL is public and does not grant private access.
• Never export OAuth or refresh tokens, API keys, passwords, seller secrets, signed private URLs, authorization headers, cookies, or other credentials.
• Remove secret fields from the payload and report the omission without treating ordinary advertising data as forbidden.

Workflow

1. Verify that the user explicitly requested a Google export or update. Resolve one exact target file and, for Sheets, the sheet and destination range or append position. If name lookup returns multiple files, list the candidates and request the file ID or URL; do not write while the target is ambiguous.
2. Use the applicable provider skill to resolve scope: $yandex-direct-campaign-builder, $yandex-metrika, $vk-ads-campaign-builder, or $avito-ads. Use get_provider_context or resolve_campaign_scope when that skill requires it. A Google export alone does not require workspace_project_id.
3. Find each report tool with search_tools, read its schema with get_tool_schema, and fetch the report with call_tool. Do not use call_write_tool merely to read or export a report.
4. Restrict the export payload to the allowed data boundary and preserve the report period, currency, attribution, provider IDs, and aggregation level needed to interpret the numbers.
5. Perform a real write with the connected Google Sheets, Google Docs, or Google Drive connector. External Google-file writes are connector actions, not LidFly MCP writes; never route them through call_write_tool.
6. Reread the changed range or document through the Google connector and verify the written values and images. A prepared table, Markdown response, or successful provider read is not a completed export.
7. Report the actual target file, changed sheet/range or document section, row/item count, provider scope identifiers used, verification result, and exact connector error if any. State separately that nothing was written to a Пространство unless a separate Workspace write was requested.

Google Sheets

• Write explicit headers and data rows, then reread the exact changed range.
• Insert a public creative with the single-argument formula =IMAGE("URL") by default.
• Adjust image display size through row height and column width.
• Use a multi-argument formula only when cell sizing cannot meet the request. For a Russian-locale sheet use semicolons, for example =IMAGE("URL";4;120;120).
• Inspect reread values for #ERROR!, #N/A, #REF!, #VALUE!, and any other formula error.
• If an image cell returns #ERROR!, replace it with =IMAGE("URL") and reread that cell. If it or any other cell still contains an error, list every affected cell address and do not declare the export successful.
• Declare a table successful only after the expected rows are present and the changed range contains no unresolved formula errors.

Google Docs

• Insert creatives as real inline images with a Google Docs connector action.
• Do not count Markdown such as ![creative](URL), a plain URL, or image alt text as an inserted image.
• Reread the document and verify the inline image/object in the document structure or in the connector's authoritative write result. If image insertion cannot be verified, report that limitation and do not claim complete success.

Connector Failures

• If the connector exposes no write action, say that no write action is available and recommend enabling write access, reconnecting Google OAuth, or checking file permissions as appropriate.
• If OAuth or permission fails, preserve and report the exact connector error and leave the target unchanged; do not silently create another file.
• Do not infer that advertising data or public creatives are prohibited. Once the target is exact and a write action is available, make the real connector call before reporting a policy or connector block.
• Never claim success from a hypothetical call, a local draft, or data displayed only in chat.

Completion Checks

Treat these as required outcome branches:

• Successful Sheet: write, reread the target range, verify row count and zero formula errors.
• Docs image: insert and verify a real inline image.
• Russian locale: use ; only for a necessary multi-argument IMAGE formula.
• Image #ERROR!: downgrade to single-argument IMAGE, reread, and report failure if unresolved.
• No write actions: recommend write enablement, OAuth reconnect, or permission review.
• OAuth/permission error: return the exact connector error without claiming success.
• Ambiguous target: stop before writing and request the exact file ID or URL.