Hi,
I have the following Zap
- User subscribes to email list
- Trigger: Copy Google Spreadsheet 1
- Trigger: Copy Google Spreadsheet 2
These Google Sheets are communicating with each other through =IMPORTRANGE, which is fine, but as soon as a copy is made, the files require to be given access again to communicate with eachother.
Since we want this all to be automatic we are wondering if this above part is also possible with Zapier.
Sheet 1 is the Sheet which is shared with the new email list subscriber.
Sheet 2 is the “backend”. Here are all the secret formula’s, which help the user get to a certain answer on Sheet1 without revealing the formulas.