How to create a Google Ads Script that imports offline conversions that are in a Google spreadsheet and then brings the import results into that same spreadsheet?

[Flávio Catania]

Hi, I'm Flávio,

Please, is it possible to use Google Ads Script to do this type of import with gclid and then have the results returned in a spreadsheet?

I searched in several places, both here on the forum and in the official documentation and I even tried to get help with Bard, lol... but I couldn't make it work in any way.

If anyone has an idea and can recommend (updated) documentation or even put here a sketch of what this code should look like, I would be very grateful!

I am used to uploading offline conversions using gclid through the import schedule tool using Google Sheets.

However, I would like to create something more elaborate using Google Ads scripts and actually my question is whether it is possible to import offline conversions with gclid using Google Ads scripts and taking information that is currently in a Google Sheets as well.

My question regarding this change from the scheduling tool to Google Ads scripts is precisely to have a return on the results of the uploads carried out, because with this return, I would like to feed this spreadsheet to be able to signal the feedback for each case and remove from the spreadsheet, in an automated manner, the cases that have already been successfully imported.

I hope I'm clearer now. Sorry for any misunderstandings, but I'm Brazilian and I'm using Google Translate to post my question here.

Thanks!

[Google Ads Scripts Forum]

Hi,

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

By reviewing your query, I understand that you are looking to import offline conversions. This feature is not available in the Google Ads Scripts.

If you have any further queries related to Google Ads Scripts, please feel free to get back to us.

Thanks

Google Ads Scripts Team.