Hi everyone,
I'm having some difficulty creating my automation.
Here is the problem:
- Every day, a new file (a spreadsheet) is imported in a specific folder on my Google Drive.
- I would like that each time a new file is added in this folder then the content of this file is copied and pasted inside another spreadsheet on my Google drive as a new tab (because it already has content).
Is this possible? I can't find the solution.
Thank you :)
+14Is the file a CSV?
How many rows of data are in the new file?
+12That shouldn’t be a problem but is a tricky set up. For your trigger step, you will select New File in Folder in Google Drive and configure it to look at the folder of interest.
Next, you will select to Copy Worksheet in Google Sheets. select the drive, for the field “Spreadsheet Containing the Worksheet to Copy” you will insert a custom value from the previous step for the id the spreadsheet. then under worksheet to copy type in the value 0 (0 is the id of the first worksheet on the spreadsheet, Zapier doesn’t like this and will throw an error but you can ignore, it will work). Then select the destination spreadsheet to copy the worksheet to.
+11Hi
Can you see if the answer that
+11Hi
I just wanted to check in with you to see if you’d managed to get things working using the suggestion above, or whether you could still use some help here. Please let us know :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
