Skip HootSutie or Buffer. You're already paying for Airtable – use it as your social media scheduler!
-
Sign in to your social media accounts Keys are stored in a SQLite database, and records are added to airtable for each account you've signed in for.
-
Schedule posts in Airtable Write your content in Airtable, and select the social account as a Linked Record.
-
Social Table handles the rest.
Docker is an easy way to build and run SocialTable.
## Build the image to run on anthoer machine
docker-compose build # Build the image
docker save -o builds/socialtable.tar socialtable
Save the image:
Configuration should be stored in a .env file.
| Parameter | Description | Required |
|---|---|---|
| PORT | Port the application listens on (for auth & webhooks) | Required |
| AIRTABLE_API_KEY | Airtable Personal Access Token or Key | Required |
| AIRTABLE_BASE_ID | ID of the base storing your posts and connections | Required |
| AIRTABLE_CONNECTIONS_TABLE | Name of the table holding your accounts. See Airtable Configuration below for details. | Required |
| AIRTABLE_POSTS_TABLE | Name of the table holding your posts. See Airtable Configuration below for details. | Required |
| META_APP_ID | APP ID for your Meta App | Required for posting to Facebook or Instagram |
| META_APP_SECRET | Secret Key for your Meta App | Required for posting to Facebook or Instagram |
| LINKEDIN_CLIENT_ID | APP ID for your Linkedin App | Required for posting to LinkedIn |
| LINKEDIN_CLIENT_SECRET | Secret Key for your Linkedin App | Required for posting to LinkedIn |
You must create at least these tables with at least these fields for SocialTable to work.
| Field | Type | Description |
|---|---|---|
| Page Name | Text | The name of the account/page/profile we're posting to |
| Platform | Text or SingleSelect | Facebook | Instagram | LinkedInk |
| Connection ID | Number | Numerical ID of the page in the local SQLite database (so we can look up the OAuth Token) |
| Field | Type | Description |
|---|---|---|
| Post At | Date & Time | The time SocialTable should post this content |
| Error | Text | The error which prevented this post from going up as scheduled |
| Post Link | URL | A link to the post, generated when the post is created |
| Copy | Long Text | The text of the post |
| Type | SingleSelect | Text | Image | Link |
| Image | Attachment | For Image Posts |
| Connection | Linked Record | Link to the Connections table |
| Connection ID | Lookup Field | Lookup for the "Connection ID" in the Connections table |
Sign into your social media accounts using these urls:
- {Appurl}/auth/linkedin
- {appurl}/auth/meta
Once you've signed in to your accounts, the OAuth tokens will be stored locally in a sqlite database. A record will be created in Airtable to represent that page/account, but the tokens themselves will not be stored in Airtable.
- Instagram Posting
- Create guides for setting up:
- General usage guide about .env stuff
- Meta App
- LinkedIn App
- Video Support
- Dockerize?
- Encrypt tokens sotred in sqlite
- Move to typescript because this is a freakin' mess
- Meta Login
- Facebook Posting
- Linkedin Login
- Linkedin Posting