Can Pipedream Workflows Connect Notion and Google Sheets with Firestore?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Hi, using Pipedream Workflows,
• I was able to connect notion + googlesheet
• I also need to have a workflow that
◦ fetches/query all documents in a particular firestore/collection into a new googlesheet spreadsheet;
◦ the firestore/documents’ fields can be edited/modified from googlesheet and reflect the changes in the firestore.
I couldn’t figure how to go about this yet. Kindly put me through.

Thank you

2

Hello ,

Pipedream is currently providing some actions for Firebase as the images below. You can try to use them for your usecase

image.png
image.png1820×896 87.4 KB

3

Thanks Leo,
For the trigger, There’s no ‘query a firebase collection’ type of event. Is there no way to query a collection into GoogleSheet, or I’m I to use GoogleSheet as the trigger?

4

Hi ,

> • fetches/query all documents in a particular firestore/collection into a new googlesheet spreadsheet;
I think you can use a Schedule trigger that runs by interval, then add a trigger to query the Firebase collection, finally put the data into Google Sheet

I think this Pipedream Speed Run video can help

5

Thank you.