Files from GCS to Google Adwords

[Sree Iyer]

Hi All,

I have setup a schedule to run daily once to upload files from GCS Bucket to Google Ads Conversion.

Source = HTTPS

Source URL = https://storage.cloud.google.com/testing_adwords_data/conversion_data.csv

The upload fails with this message "No Header  row found in this sheet"

Even though the CSV file has the Header row.

But the same CSV file, when I upload it manually from my computer, then it works

My question -

1) Does this setup from GCS to Google Ads works ? Is it possible to do this ?

2) If not, what other options do I have. I don't want to everyday manually download the file from GCS to my local machine and upload from my local machine to Google Ads.

3) I don't understand why is it giving the "No Header row found in this sheet". Even though there is Header Row ? Secondly how come the same CSV file when I upload manually works ?

Is there some other setup I need to do, to make this work.

Any help is highly appreciated !!!

Thank you.

[Google Ads Scripts Forum Advisor]

Hi Sree,

 

It appears that you have created a new thread with the same concern as the one you have previously opened in this forum thread. I would recommend using only one of the thread for better tracking of the issue. Allow me to reiterate my response from that thread below:

 

Hi Sree,

 

I am Maia from the Google Ads Scripts team. Thank you for reaching out to us.

 

I'm afraid that we do not have access to the Source URL you have shared. However, kindly share with us the following details below so that we may be able to investigate further:

• Google Ads CID 
• Script name
• Shareable link of the spreadsheet being used or the file you are using for bulk uploads

Kindly send the requested details above via ‘Reply privately to author’ option. However, if the private option is not available on your end, then please send it over through this email <googleadsscr...@google.com> instead.

 

To address your setup questions, you may refer to the instructions stated in Create bulk upload from Google Drive document. In regards to your additional questions, we will be needing the details mentioned above for us to address your concerns accurately.

 

Best Regards,

Angel Maia Google Ads Scripts Team

ref:_00D1U1174p._5004Q2bw6Au:ref

[Sree Iyer]

Thank you so much.

Here is the answer to your questions -

Here is our URL - https://ads.google.com/aw/conversions/uploads?ocid=251103746&euid=606651096&__u=3583060504&uscid=251103746&__c=4081610354&authuser=0&subid=us-en-ha-awa-bk-c-000%21o3~CjwKCAjw46CVBhB1EiwAgy6M4uy63N2Np_aWOgMT_29uHIF7uqXi6KmabFYKSXkMIpI8F4U19brjARoCKVcQAvD_BwE~76351060526~kwd-10967328679~6466339656~562673792568

• Google Ads CID  - 762-013-3727 easyknock.com v2
• Script name -  Not sure what information I need to supply. Can you please elaborate?
• Shareable link of the spreadsheet being used or the file you are using for bulk uploads - I am trying to upload from GCS to google ads

                link - https://ads.google.com/aw/conversions/uploads/schedules?ocid=251103746&euid=606651096&__u=3583060504&uscid=251103746&__c=4081610354&authuser=0&subid=us-en-ha-awa-bk-c-000%21o3~CjwKCAjw46CVBhB1EiwAgy6M4uy63N2Np_aWOgMT_29uHIF7uqXi6KmabFYKSXkMIpI8F4U19brjARoCKVcQAvD_BwE~76351060526~kwd-10967328679~6466339656~562673792568

              File is in GCS - https://storage.cloud.google.com/adwords_data/conversion_data.csv

                

Screen shot -

                 

when I try to upload the file from GCS - I used the source = HTTPS and the URL = https://storage.cloud.google.com/adwords_data/conversion_data.csv

Also I have attached the same file in this Email.

Please let me know if you need any other information.

Thank you for your help.

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/PY4qa000000000000000000000000000000000000000000000RDGLRV00nvaJCOLDRuyFrXc9Z-P7QA%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hello,

Thank you for your response.

Based on the given screenshots and the data provided, it appears that your concern is not related to the Google Ads scripts, but more of a specific conversion functionality within Google Ads UI. Take note that our support team primarily provides support and assistance with the scripts implementation within a specific Google Ads account which you can observe under Tools and Settings > Bulk upload > Scripts. 

Having said that, I believe that it’s best if you raise your concern to the Google Ads products support team as they are more knowledgeable on this aspect and can assist you further with your concern. You may contact them through this link.

Regards,

James Howell Google Ads Scripts Team

ref:_00D1U1174p._5004Q2bw6Au:ref