Action: Display original data over multiple spreadsheets
Status: Open · Asked by Andrea1711 on · 0 views
Hi Pabbly fellows,
My team works and communicates by Google Sheets; as a result, we need to use a lot of combination formulas such as Importrange, Vlookup,... It causes my Excel files to respond slowly and sometimes it goes wrong. So, I have some questions before subscribing officially as below:
1. Can Pabbly display accurately the data from the original spreadsheet over multiple spreadsheets and versus?
2. Can I use Pabbly when my Google Sheet is in "View" mode?
I'm looking forward to any comments from you guys. Thanks in advance!!!
Hi @Andrea1711,
Hi Pabbly fellows,
My team works and communicates by Google Sheets; as a result, we need to use a lot of combination formulas such as Importrange, Vlookup,... It causes my Excel files to respond slowly and sometimes it goes wrong. So, I have some questions before subscribing officially as below:
1. Can Pabbly display accurately the data from the original spreadsheet over multiple spreadsheets and
I assume you want to sync data from one spreadsheet across multiple spreadsheets. To do this, you can follow the steps given in the video shared below to understand how to sync data between two spreadsheets.
youtube.com/watch?v=txyuSjy9u64
Since you want to sync data across multiple spreadsheets, you would have to add multiple 'Google Sheets: Update Cell Value' action steps to your workflow, each for a different spreadsheet.
versus?
You will need to set up multiple workflows, configuring the 'Google Sheets: New or Updated Spreadsheet Row' trigger step for each of your spreadsheets.
2. Can I use Pabbly when my Google Sheet is in "View" mode?
To make automations work, you need to have access to edit the spreadsheet. If you only have viewable permissions, it won't work.