Hello there,
I am new to using Sheetgo and am currently working on a project that involves consolidating data from multiple Google Sheets into a single master sheet. I have set up basic connections between the sheets; but I am facing a few challenges that I hope you can help me with.
My source sheets are updated regularly; with new rows added periodically. Is there a way to dynamically update the range in the Sheetgo connection so that it includes all new data without manually adjusting the settings each time?
Some data entries might overlap between the sheets. What is the best practice for identifying and handling duplicates in the consolidated master sheet? Should I use a unique identifier column, or is there a built in feature in Sheetgo that can assist with this?🤔
Occasionally; I encounter errors when the connection tries to pull data from a sheet that has not been updated in a while. This sometimes causes the workflow to stop. How can I set up error handling to either skip such sheets or send me a notification without disrupting the entire process?🤔
As the data grows; I am concerned about performance and manageability. Are there any recommended best practices for handling large data sets efficiently using Sheetgo?
Also, I have gone through this post; https://community.sheetgo.com/d/441-how-can-i-use-the-blue-prism-unit-performance-analysis-template which definitely helped me out a lot.
I am excited to make the most out of Sheetgos capabilities and ensure that my data consolidation process is as smooth and efficient as possible.
Thank you in advance for your help and assistance.😇
