Conversion Import errors with "No header row was found for this spreadsheet" despite visible header row

[Joris Dietziker]

Hello,

When using the scheduled conversion upload I sometimes face the issue that the process  is throwing a "No header row was found for this spreadsheet" error despite the header row being there.
In the past 6 months it happened once in a blue moon, but now has been consistently failing for a week in a row, despite us not having changed anything in our process.




When using the same process and a new Filename, it works for the first time, before reverting to also throwing an error.

When manually uploading the file, no errors occur and the file is processed without issue.

Any ideas why the automated upload cannot process the file correctly?
Thanks,
Joris

[Google Ads Scripts Forum Advisor]

Hi Joris,

 

Thank you for reaching out to the Google Ads Scripts Support Team.

 

Would you be so kind as to provide the following information so our team can further investigate your concern and assist you?:

• Google Ads account ID
• Name of the script
• Screenshot showing the error
• Shareable link of the spreadsheet the script is using
  • How to get a shareable link - https://support.google.com/docs/answer/2494822?hl=en&co=GENIE.Platform=Desktop#zippy=,share-a-file-publicly
  • You may also opt to attach a local copy of your spreadsheet in order to reduce back and forth

 

You may send these via the Reply privately to author option. Note that you may need to join the Google Group for you to use this option. If this option is not available on your end still, you may send it through our email (googleadsscr...@google.com) instead.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2ojhBl:ref"

Thanks,
 

Google Ads Scripts Team