Google Ads add-on for Google Sheets – "Select columns" and refresh options not showing

[小林風輝]

I am using the Google Ads add-on for Google Sheets and encountering the following issue:

- When creating a new report, I can select an account, but the "Select columns" list remains empty and no refresh frequency options are shown.

**Checks already performed:**
- The account is a direct child account (not via MCC).
- Access level is "Standard".
- Re-authentication done (removed and re-authorized app access).
- Date range set to a period with confirmed data.

Please see the attached screenshot for reference.

Could you advise on the possible cause and any workaround or fix?

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads Scripts support team.

I would like to inform you that we haven’t received any attachment with this email.

Please be noted that our team will only provide support for issues/concerns related to the Google Ads Scripts and Google Ads add-ons in Google Sheets are not in our scope. Regarding the script issue, could you please elaborate more on the issue and provide us with the following details?

• Google Ads account ID/CID
• Name of the affected script
• Screenshot of the error (if any)
• Shareable spreadsheet link that you are using in the script. You may refer to this article to share a file publicly
• Email Id with which you have logged in to the Google Ads account

You can share the requested details via Reply privately to the author option or a direct private reply to this email.

Thanks,
 

Google Ads Scripts Team

Feedback
How was our support today?

               
[2025-08-12 14:20:53Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01sypKK:ref" (ADR-00329696)

[小林風輝]

Hello,

Thank you for your response.

This issue is not related to a custom Google Ads Script, but to the official Google Ads add-on for Google Sheets.  
While I understand that Google Sheets issues may normally be outside your scope, this add-on uses the Google Ads API, so I am hoping your team could at least help confirm if the behavior is expected or a known bug.

Issue:
- When creating a new report in the Google Ads add-on for Google Sheets, I can select an account, but the “Select columns” list remains empty and no refresh frequency options are displayed.

What I have tried:

- The account is a direct child account (not via MCC).
- Access level is “Standard”.
- Re-authentication done (removed and re-authorized app access).
- Date range set to a period with confirmed data.

- Issue reproduced across multiple browsers and spreadsheets.

Unfortunately, I cannot share the actual spreadsheet due to confidential information, but I have attached a screenshot with all sensitive details masked, along with step-by-step instructions to reproduce the issue.

Reproduction steps:
1. Open Google Sheets and launch the Google Ads add-on.
2. Click “Create new report” and select an account.
3. Observe that the “Select columns” section is empty and refresh options are not shown.

Please see the attached screenshot for reference.  

**Attachment description:**  
Screenshot showing the “Create a new report” panel in the Google Ads add-on for Google Sheets.  
The “Select columns” section is empty and no refresh frequency options are displayed, despite an account and date range being selected.

Could you confirm whether this is a known issue or if there is any workaround?

Thank you for your understanding.

2025年8月12日火曜日 23:21:26 UTC+9 Google Ads Scripts Forum Advisor:

[Google Ads Scripts Forum]

Hi,

I would recommend you refer to the below given steps to create a new report using the Google Ads add-on for Google Sheets:

1. 1.  Go to Google sheets.
2. Click the plus sign under “Start a new spreadsheet.”
3. From the menu at the top of the page, click Add-ons.
   
4. Hover over “Google Ads,” then select Create a new report.
   
5. If prompted, choose a Google Ads account to use for the spreadsheet. If you only have one Google Ads account associated with the Google account that you’re logged into, the spreadsheet will automatically be associated with that account.
6. Enter the report parameters (like date range, report type, filters, and more) in the window that appears on the right.
   
7. Click Create report.

Kindly refer to the help center article About the add-on for Google Sheets to get more information. If you still need any further assistance, could you please share the Google Ads customer ID so that we can route you to the appropriate support team?

You can share the requested details via Reply privately to the author option or a direct private reply to this email.

Thanks & Regards,

Google Ads Scripts support team.

[小林風輝]

Thank you for the instructions.  
I have already tried all of these steps exactly as described, but the issue persists.  
Please note that the “Select columns” list is still empty and refresh options are not shown.  
As this is a public forum, I’m unable to share my Google Ads Customer ID here.

2025年8月14日木曜日 15:16:40 UTC+9 Google Ads Scripts Forum:

[Google Ads Scripts Forum Advisor]

Hi,

As informed earlier our team can only provide support for issues/concerns related to the Google Ads Scripts. If your issue is solely occurring in Google Sheets, you may reach out to the Google Sheets support team for further assistance. If the issue is with the usage of a Google Ads Script, you can send the requested details to our support email “googleadsscr...@google.com”.

Thanks,
 

Google Ads Scripts Team

Feedback
How was our support today?

               

[2025-08-14 15:39:55Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01sypKK:ref" (ADR-00329696)