All Collections
JSON URL
How to auto export JSON URL data to Google Sheets, Excel Online and CSV
How to auto export JSON URL data to Google Sheets, Excel Online and CSV

JSON URL to CSV, XLSX and Google Sheets | Full data objects | Flatly

Support avatar
Written by Support
Updated over a week ago

Important: Flatly will sync full, current JSON URL data, not just new, single rows, to your cloud drives. This is a one-way sync to cloud drives.

Select Universal JSON as your Data Source.

Flatly supports Basic Auth headers.
​ 
 Alternatively, you can provide auth parameters in your URL directly. Edit the URL until it is in this form:

https://yourfile.json?&auth=yourkey
​ 
 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

Paste your full JSON URL into the Authorization prompt.

Set the remaining preferences for your Job, including frequency: (every 10 minutes, every 1 hour, every 1 day, etc.)

Click Run Once Now to test.

Click Run Per Schedule.

Done. You can safely log out of Flatly. It is advisable to return periodically to check your logs.

Did this answer your question?