Data Exports & Sync
πŸ’½

Data Exports & Sync

⚠️
Note: Data Exports & Sync is only available for accounts with Business Plan.

Export & Sync to Google Sheet

Step 1: Create a sheet

  • Invite sheet-bot@blackmagic-so.iam.gserviceaccount.com as an Editor.
notion image

Step 2: Enable Data Sync

  • Click the Google Sheet Sync task.
notion image
  • 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.
notion image
Β 
From now, the task will run every 1 hour.

Example output

notion image

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
Your {TEAM_ID} and {API_KEY} can be found in https://blackmagic.so/dashboard/exports
VisitΒ API DocumentationsΒ for more details on how to use the APIs.