how to export performance data from Microsoft ads scripts to Google sheets?

Aaron Hackett 0 Reputation points
2026-08-17T03:06:55.67+00:00

I cannot export performance data from Microsoft ads scripts to Google sheets? is this correct?

Microsoft Advertising | Bulk edits | Use Google imports
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MS Advertising - Dagmara 640 Reputation points Microsoft External Staff Moderator
    2026-08-17T08:33:46.8766667+00:00

    Hello Aaron,

    Thank you for using our Microsoft Advertising Learn Q&A!

    Yes, exporting Microsoft Advertising data to Google Sheets is a supported scenario when using Microsoft Ads Scripts.

    Microsoft Ads Scripts can call Google services such as Google Sheets, Google Drive, and Gmail through Google's APIs. Microsoft even provides a sample script that reads data from Google Sheets, updates Microsoft Advertising data, and writes results back to a Google spreadsheet. This demonstrates that integration with Google Sheets is supported when the required Google authentication and API configuration are set up correctly.

    Calling Google services - Microsoft Advertising API | Microsoft Learn

    If you're unable to export performance data to Google Sheets, the issue is likely related to the script implementation, Google API authentication, permissions, or configuration rather than a general limitation of Microsoft Ads Scripts. To help troubleshoot this further, please provide any error messages and the relevant section of your script.

    Authenticating with Google services - Microsoft Advertising API | Microsoft Learn

    Our support teams are pleased to engage in more in-depth discussions about your account through phone, chat, or email to offer review assistance, please see our support page to reach out!

    I trust that the details shared here will partially address your inquiry. Should you have any further questions, feel free to contact our support. Additionally, I’ve sent you a private message, please don’t hesitate to reply if you require further assistance.

    Kind regards, 

    Dagmara | Microsoft Advertising Specialist | 800-518-5689

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.