Firestore data to Excel.... but how ?

Hi Everyone,

I have been trying to tweak Zapier for the last couple of hours but without success. And I thougt I might ask around before giving up.

I have a firebase collection with several documents inside it. I’m looking for a way to send the fields from each documents to excel rows.

Exemple:

In Firestore I have a collection named People which contains several documents:

Document 1

Document 2

And I want to get every document in Excel:

Is Zapier able to do that ?

Many thanks for reading :)

Jul

Page 1 / 1

FYI: Zaps work best for new records going forward when the Zap is turned ON.

If you’re trying to backfill existing records, look into a manual export/import or try https://transfer.zapier.com.

Firebase Trigger: New Document within a Firestore Collection

Thanks Troy for the reply.

I get it, Zap works best for new records, and that’s fine with me :)

My issue is that right now, zapier sends all my fields in one cell. In my exemple each field (name, age, city) goes to a different column.

With Zapier, everything goes to column A, in a unique cell , like this:

column A

name age city

Can you please provide a screenshot of how the data comes thru on the trigger step?

Here you have my trigger, which looks fine.

Problem is with the action, everything goes to Col$a , i have no option to change that.

Then the result in excel, all the fields are put together in the same cell.

That’s because you’ve mapped all the data points everything to Column A

Make sure your Excel file has headers for each of the columns in Row 1. (e.g. Name, Age, City)

Awesome, thank you !

Sign up