Note: Data Exports & Sync is only available for accounts with Business Plan.
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.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F74e819d7-7e50-4729-939d-63e7c8010fcb%2FCleanShot_2022-05-02_at_22.53.042x.png?table=block&id=18220c12-74d1-4811-811d-54d366b07c0d&cache=v2)
Step 2: Enable Data Sync
- Click the Google Sheet Sync task.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F96ca92e2-b70a-4e4d-88a9-af0b3729af8e%2FCleanShot_2022-05-02_at_22.51.052x.png?table=block&id=66440c93-3211-4c4a-b0f5-9953dc167fcc&cache=v2)
- 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](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F7068fee5-84d6-4a49-b813-c009dd2530a0%2FCleanShot_2022-05-02_at_22.54.282x.png?table=block&id=9382cc44-319b-479e-8e68-7ed6f70c9fdb&cache=v2)
From now, the task will run every 1 hour.
Example output
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F177209aa-0de1-421d-8a1a-ee1b93ecbfeb%2FUntitled.png?table=block&id=b6feddb9-0cc8-4801-9561-0e28e886b6fb&cache=v2)
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.