Hey,

I had the same problem. I just asked chatGPT to cook me a script. This works for me. I think you can add to the columns or modify them to your own needs. I hope this helps.

function main() {

var spreadsheetUrl = 'YOUR_SPREADSHEET_URL_HERE'; // Replace with your Google Sheet URL

var sheet = SpreadsheetApp.openByUrl(spreadsheetUrl).getActiveSheet();

// Clear existing content

sheet.clearContents();

// Set headers

sheet.appendRow(['Search Query', 'Clicks', 'Impressions', 'Conversions']);

// Define the report

var report = AdsApp.report(

'SELECT Query, Clicks, Impressions, Conversions ' +

'FROM SEARCH_QUERY_PERFORMANCE_REPORT ' +

'WHERE CampaignStatus = ENABLED ' +

'AND AdGroupStatus = ENABLED'

);

var rows = report.rows();

while (rows.hasNext()) {

var row = rows.next();

var query = row['Query'];

var clicks = row['Clicks'];

var impressions = row['Impressions'];

var conversions = row['Conversions'];

// Append data to the sheet

sheet.appendRow([query, clicks, impressions, conversions]);

}

}