Hi all,
I have an app that stores records in a Cloud Firestore using Firebase, I’m trying to get the information submitted into the app onto a Google Sheets spreadsheet using Zapier.
I created a new Zap and set it up as follows:
- New Document within a Firestore Collection
- Chose Account
- Customise Record with the follow query
"orderBy": [{
"field": {
"fieldPath": "`Operative Name`"
},
"direction": "DESCENDING"
}] - Create Spreadsheet Row in Google Sheets
- Chose Account
- Chose Spreadsheet, then worksheet then added fields
- Sent test successfully
My concern is how can I have my spreadsheet update automatically each time the submit button is tapped on the app and have it added as a new row?
Right now I get the initial row I set it up with, but tapping submit in the app does nothing.
Really hope someone can help, it would be greatly appreciated!
I’m currently on the free plan.
Best answer by steph.n
View original