Important: Flatly will sync full, current Firebase JSON nodes, not just new, single rows, to your cloud drives. This is a one-way sync to cloud drives.
Setup time: Approximately 3 minutes.
STEP 1: Create a Service Account:
Follow the instructions provided by Google Cloud:
Assign the Firebase Viewer role to your new Service Account and then download the JSON key to safe temporary place on your computer. You will need the JSON key to authorize this connection in Flatly.
STEP 2: Check your Database URL and path:
Follow Google's instructions to find your Database URL:
A path example:
pets/cats
Step 3: Select your Data Destination
Select your Data Destination from the following:
Google Drive (includes Google Sheets)
Microsoft OneDrive (includes Excel Online)
Microsoft OneDrive for Business (includes Excel Online)
Box
Dropbox
Microsoft Azure
Amazon S3
Step 4: Authorize Firebase
Enter your credentials from steps 1 and 2.
At the Select File to Flatten step, experiment by running jobs with Uniform JSON and Varied JSON and check the layout in your flat file to see which one you need.
Set the remaining preferences for your Job, including frequency: (every 10 minutes, every 1 hour, every 1 day, etc.)
Done. You can safely log out of Flatly. It is advisable to return periodically to check your logs.
Reminder: Firebase may charge you for bandwidth depending on your plan. If you have a gigantic database, be mindful of the bandwidth being used every time Flatly reads your database.
Troubleshooting
-Try both parent nodes and child nodes to see what works best for you.
-Experiment with Uniform JSON and Varied JSON to see which one fits.
-Make sure your clipboard is not truncating your key when you copy it.
-Double check every single character and space in your path, leave out forward slashes if they do not match the example provided.