I want to extract billing data from Google Ads but for some reason Google Ads doesn’t let me choose a folder. So I have to use Google Drive itself for this reason. But then I cannot connect files in Google Drive via Sheetgo; Sheetgo asks for a specific folder in Google Drive. Can you help please?
KananAliyev I’m pretty sure Sheetgo has the option to consolidate multiple files and not just one folder.
Just select multiple files as a source when creating your connection.
Thanks @Holin I can consolidate multiple files but the problem is that every day a new file is coming in. So I get a new file on a daily basis which means I have to add that new file manually to Sheetgo. Is there a way to do this automatically or can Sheetgo consider My Drive in Google Drive as a folder in itself?
KananAliyev can Sheetgo consider My Drive in Google Drive as a folder in itself?
Currently it cannot. How do you get the new file?
Via a script?
Is there no way to tell the script to place the file into a specific folder?
Then you could connect to the entire folder easily.
Hey @Support from Sheetgo! Thanks for reply. The file I’m talking about is Google Ads Billing report and it is added to Google Drive automatically via Google Ads. Is there a way to write a script so that the report comes to specific folder?
This is more about Google Ads, still would be helpful if you could help with that.
Have a nice day!
KananAliyev I’m pretty sure @Gonzalo can help you with a script! :)
You can contact him directly at firstname.lastname@example.org
Powered by FreeFlarum.(remove this footer)