Automate Google Ads Reports and Email a CSV Attachment via Scripts

Google Ads provides built-in reporting tools that allow you to schedule reports and send them via email. However, there is a major limitation: reports can only be sent to authorized users in the Google Ads account, and recipients receive a link to download the report, which requires them to log in.

For many people, this can be inconvenient, especially if the report needs to be shared with team members or external stakeholders who do not have direct access to the Google Ads account.

One way to solve this is to use Google Ads Scripts.

What is Google Ads Scripts?

Google Ads Scripts is a powerful tool that allows you to automate campaign management and reporting using JavaScript. With Google Ads Scripts, you can:

• Generate and schedule custom reports.
• Filter and format data as needed.
• Email reports as attachments.
• Automate bid adjustments, keyword optimizations, and other campaign management tasks.

In this tutorial we will go through he process of automating and scheduling a search keyword performance report that will be sent via email as a CSV file—without requiring recipients to log into Google Ads.

Steps to Schedule and Automate an Email Google Ads Report as a CSV Attachment

1. Open the Google Ads Scripts Section

1. Sign in to your Google Ads account.
2. Click on the Tools and Settings icon (wrench icon) in the top menu.
3. Under the Bulk Actions section, select Scripts.
4. Click the + New Script button.

2. Copy and Paste the Script

Below is a script that fetches search keyword performance data for a specific campaign, formats it into a CSV file, and emails it to the specified recipients:

function main() {
  // Fetch the keyword performance report data
  var report = AdsApp.report(
    "SELECT CampaignName, AdGroupName, Criteria, KeywordMatchType, Status, SystemServingStatus, FinalUrls, " +
    "Impressions, Interactions, InteractionRate, AverageCost, Cost, QualityScore, AverageCpc " +
    "FROM KEYWORDS_PERFORMANCE_REPORT " + 
    "WHERE CampaignName CONTAINS_IGNORE_CASE 'Competitor Campaign' " + // Filter for specific campaigns
    "DURING ALL_TIME"
  );

  // Define the headers for the CSV file
  var data = [[
    "Keyword status",
    "Keyword",
    "Match type",
    "Campaign",
    "Ad group",
    "Serving Status",
    "Final URL",
    "Impressions",
    "Interactions",
    "Interaction rate",
    "Avg. cost",
    "Cost",
    "Quality Score",
    "Avg. CPC"
  ]];

  var rows = report.rows();
  var dataAdded = false; // Flag to check if data is added

  // Loop through the rows and extract data
  while (rows.hasNext()) {
    var row = rows.next();

    var servingStatus = row['SystemServingStatus'] || "Unknown"; // Default to "Unknown" if missing

    var rowData = [
      row['Status'] || "Unknown", // Keyword status
      row['Criteria'] || "", // Keyword
      row['KeywordMatchType'] || "", // Match type
      row['CampaignName'] || "", // Campaign name
      row['AdGroupName'] || "", // Ad group name
      servingStatus, // Serving status
      row['FinalUrls'] || "", // Final landing page URL
      row['Impressions'] || 0, // Number of times ad appeared
      row['Interactions'] || 0, // Number of clicks or interactions
      row['InteractionRate'] || 0, // Click-through rate (CTR)
      row['AverageCost'] || 0, // Avg. cost per interaction
      row['Cost'] || 0, // Total cost
      row['QualityScore'] || 0, // Google Ads Quality Score
      row['AverageCpc'] || 0 // Average cost per click (CPC)
    ];

    if (rowData.some(cell => cell.toString().trim() !== "")) {
      data.push(rowData); // Add row to CSV data
      dataAdded = true;
    }
  }

  // If no data found, add a default message
  if (!dataAdded) {
    data.push(["No data found for the specified criteria."]);
  }

  // Convert data array into CSV format
  var csvData = data.map(row => row.map(cell => `"${cell}"`).join(",")).join("\n");

  // Generate timestamp for the filename
  var now = new Date();
  var timeZone = AdsApp.currentAccount().getTimeZone();
  var formattedDate = Utilities.formatDate(now, timeZone, "yyyy-MM-dd");
  var filename = 'All-Time_Search_Keyword_Report_' + formattedDate + '.csv';

  // Create CSV Blob (file format)
  var csvBlob = Utilities.newBlob(csvData, 'text/csv', filename);

  // List of recipients to receive the email - make sure to change to your email
  var recipientEmails = [
    "emailexample1@gmail.com",
    "emailexample2@gmail.com"
  ];

  // Send email with CSV attachment
  MailApp.sendEmail({
    to: recipientEmails.join(","), // Convert array to a comma-separated list
    subject: "All-Time Search Keyword Report",
    body: "Attached is the automated CSV report for " + formattedDate + " with all-time search keyword data.",
    attachments: [csvBlob] // Attach the generated CSV file
  });
}

3. Customize the Script

• Modify the query to select the data fields relevant to your report.
• Change the campaign name filter (WHERE CampaignName CONTAINS_IGNORE_CASE 'Competitor Campaign') to match your campaigns.
• Update the recipient emails in var recipientEmails to send reports to the right people.
• Adjust the date range if necessary (e.g., change DURING ALL_TIME to DURING LAST_30_DAYS).

4. Save and Authorize the Script

• Click Save.
• Click Preview to test the script.
• Authorize the script when prompted.
• Click Run to manually execute the script.

5. Schedule the Script

To run the script automatically:

1. Go to Scripts in Google Ads.
2. Click on your script.
3. Click Create Schedule.
4. Select the frequency (e.g., daily, weekly, or monthly).
5. Save the schedule.

Benefits of Using Google Ads Scripts for Automated Reports

No Login Required – Recipients get a CSV attachment, no need to log into Google Ads.
Full Customization – Modify the data fields, filters, email subject, and content.
Improved Workflow – Automate reporting instead of manually exporting data.
Scheduled Execution – Run the script daily, weekly, or monthly.

Conclusion

Using Google Ads Scripts, you can fully automate performance reports and send them directly via email as attachments. This method eliminates the need for logging in and allows you to customize reports for different users.