Guide Effortlessly Sync Adsterra Stats with Google Sheets: A Complete Automation Guide

Step-by-Step Guide:​

1. Set Up a Google Sheet​

1. Create a new Google Sheet:
   • Open Google Sheets, and create a new spreadsheet.
   • Name the sheet something relevant, like "Adsterra Stats."
2. Add Headers to Your Sheet:
   • In the first row, add headers to the columns for the data you'll be collecting.For example:
     • A1: Placement Sub ID
     • B1: Impressions
     • C1: CPM
     • D1: Revenue
     • E1: Clicks
     • F1: CTR
     • G1: Date
   • This will serve as the data table where stats from the Adsterra API will populate.

2. Open Google Apps Script​

1. Go to the Script Editor:
   • In your Google Sheet, click on Extensions → Apps Script to open the Google Apps Script editor.
2. Add the Script:
   • Copy and paste the script into the editor. Here is the full script, Don't forget to add your API :
   • javascript
     
     
     Code:

     function getAdsterraDailyStats() {
     const apiKey = "XXXXXXXXXXXXXXXXXXXXXXXXX";  // Your API key
     const sheet =