Help Needed: Script to Export Exact Campaign Keywords to Google Sheets (Not Search Terms)

Hi,

I’m reaching out for support with a Google Ads Script I’ve been trying to use to automatically export monthly keyword performance data from a specific campaign into a Google Sheet.

I'm not a developer, and I've created the script with help from ChatGPT, but I'm having trouble getting it to work as expected.

• Export only the keywords I have manually added in the campaign, including their correct match types (e.g. [keyword], "keyword", keyword) — not the search terms or matched variants.

• Structure the export month by month, one row per keyword per month.

• Make it work retroactively, starting from the campaign launch in January 2024.

• Have it automatically update each month, appending new data without duplicating previous entries.

Here is the Google Sheet where I want to collect this data:
🔗 My sheet model

1. The script seems to include search terms or variant queries, not the exact keywords as set in the campaign.

2. I can’t figure out how to make the script retrieve historical data by month since the campaign started.

3. I’d like the process to run monthly and automatically, updating the sheet without re-writing or duplicating rows.

I would really appreciate your help in understanding how to achieve this — or if you could point me to a template/script that already solves this problem.

Thanks so much in advance,