This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I wish to download multiple google sheets from Google drive. I have used the Google sheets tool but it extracts one sheet at a time.
I can use multiple google sheets tool and select one sheet at a time and get the results. But this is not feasible when we haveextract information from 100 google sheets from the Google Drive. Can anyone please tell me if there is a way out to extract multiple google sheets at one time from Google Drive?
You would need to build a batch macro to do this. You would need to set up a list of sheets you want to read in and use action tools within the macro to update the Google Sheets Input tool to loop through them one by one.
If they have different schemas (field names) you'll need to check the option in the Interface Designer stating that each iteration will have a different output and then choose the option you'd like to use to address that.