Note: Data Exports & Sync is only available for accounts with Business Plan.
Export & Sync to Google SheetStep 1: Create a sheetStep 2: Enable Data SyncExample outputExport raw JSON/CSV with API
Export & Sync to Google Sheet
Step 1: Create a sheet
- Create a new sheet (click: https://sheet.new)
- Invite
sheet-bot@blackmagic-so.iam.gserviceaccount.com
as an Editor.

Step 2: Enable Data Sync
- Click the Google Sheet Sync task.

- Enable the export task
- Enter the spreadsheet URL
- Click βTestβ to see if the setup is working.
- Click βRun Nowβ, then wait for it to complete.
- Verify that the data looks good in the sheet.
- Click Close.

Β
From now, the task will run every 1 hour.
Example output

Export raw JSON/CSV with API
Use these URLs:
- JSON:
https://api.blackmagic.so/data/teams/{TEAM_ID}/tweets?key={API_KEY}&format=json
- CSV:
https://api.blackmagic.so/data/teams/{TEAM_ID}/tweets?key={API_KEY}&format=csv
VisitΒ API DocumentationsΒ for more details on how to use the APIs.