Hello! I have a very simple scenario that extracts information from single google sheets to update a final file with the same columns.
As I am currently managing it:
I have to duplicate every scenario based on a different google sheet file
The second action add a row always refers to the same file. In the first one watch new rows, file changes. This was manageable at the beginning but now things are escalating pretty quick, and duplicating scenarios all the time is a bit boring.
I was wondering if you have some suggestion on how to update a final google sheet with submissions from different files all saved into a single Google Drive Folder.
Many thanks for your help
Hi @Michelangelo_Romano
It seems you are watching the changes in every sheet. So for watching the updates, you will need different scenario for every sheet as you are doing.
If you require additional assistance, please don’t hesitate to reach out to us.MSquare Support here Youtube Channel
2 Likes
samliew
December 21, 2023, 6:02am
4
You may be interested in this thread, which was discussing the same issue a while ago
Hi Makers,
I’ve got a client who needs to watch changes in a bunch of Google Sheets. I’m trying to think through more elegant ways to grab row updates once or twice a day from a group of Sheets, other than making a separate scenario for each one triggered by a Watch Changes module. I think this approach would also require a different webhook be added to the Make add-on in each Sheet, which would be a real hassle for the client, who understandably is not about to give me access to their Google a…
2 Likes
Hello @samliew thanks for suggesting it! I will try!
