Data Exports & Sync

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

• Go to https://blackmagic.so/dashboard/exports

• 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.

Example output

Export raw JSON/CSV with API

• 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