Can I connect mutliple files in Google Drive itself, not Google Drive folder

KananAliyev

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?

Holin

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.

KananAliyev

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?

Support from Sheetgo

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.

KananAliyev

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!

Support from Sheetgo

KananAliyev I’m pretty sure @Gonzalo can help you with a script! :)

You can contact him directly at gonzalo@sheetgo.com