Bulk upload and schedule social posts
Last updated: March 26, 2024
Available with any of the following subscriptions, except where noted:
Marketing Hub Professional , Enterprise |
Legacy Marketing Hub Basic |
With the bulk scheduling feature in HubSpot's social publishing tool, you can plan and schedule your social posts in advance. When doing so, you can schedule up to 300 posts per bulk upload.
This allows you and your team to coordinate campaigns, improve your reach, and scale your social media marketing.
Prepare your bulk scheduling import file
To schedule social posts in bulk, first you'll need to prepare your import file:- In your HubSpot account, navigate to Marketing > Social.
- In the upper right, click Schedule in bulk.
- In the dialog box, select one of the following options:
- Download Excel import template (Recommended): download a template with a date column pre-populated based on your custom social publishing schedule.
- Download CSV import template: download a generic template.
- Open the downloaded import template file on your device. There are six main columns in the import template files:
- Account: the social account where you want the post published. If you're using the Excel template file, you can select an account from the dropdown menu in the column cells. This field is required.
- Date: dates must entered in the format "mm/dd/yyyy hh:mm". For example, "3:00 PM on April 15, 2018" would be formatted as "04/15/2018 15:00". You can use formulas to calculate your date fields, and HubSpot will use the derived value of the formula. This field is required.
- Message: the actual content of your post. When bulk uploading social posts, you cannot use @mentions or tags for Facebook or LinkedIn social posts. However, for Instagram and X, any mentions will not be auto-completed, but will be acknowledged by the network when the post is live. This field is required.
- Link: the URL that you are sharing in your post. All links will be shortened automatically. You can also include your link in the message column as part of your post, or publish a post with no link at all. This field is optional.
- Photo URL: the URL of the image you want to attach to your post. This field is optional.
- Campaign: the campaign to associate with your post. Match the spelling and capitalization of an existing campaign to associate it or enter a new campaign name to have that campaign created in HubSpot. If you're using the Excel template file, you can select a campaign from the dropdown menu in the column cells. This field is optional.
- These columns can be in any order in the file you upload, but they must be present on the first page of your spreadsheet. Any information included on other pages or in other columns will be ignored.
- When you're done adding your social posts, save your template file and navigate back to HubSpot.
Please note: you must save your template as an XLS or XLSX file if your social posts include accented characters (e.g. in German or French) or non-Latin symbols (e.g. in Japanese).
Upload your bulk scheduling import file
After preparing your import file, upload it to schedule your posts. Depending on how many posts you're scheduling, your import can take 15 minutes to 24 hours to process.
Any posts in the import that are scheduled to publish while the file is being processed will result in an error. To avoid this, we recommend uploading scheduled posts a day in advance.
- In your HubSpot account, navigate to Marketing > Social.
- In the upper right, click Schedule in bulk.
- In the dialog box, click Select a file or drag and drop your import template file into the Upload CSV/Excel File box.
- In the bottom left, click Upload. Once your import template file has been uploaded and processed, you'll be redirected to the Uploaded tab in the social publishing tool.
Review your uploaded social posts
You can return to your uploaded posts at any time. To review all uploaded posts:- In your HubSpot account, navigate to Marketing > Social.
- In the left sidebar menu, click Uploaded.
- To schedule the posts for publishing, click Schedule [x] posts.
- To keep editing the posts in HubSpot, click Move all to drafts.
- To delete the uploaded posts, click Cancel upload.
- You can also manage individual posts:
- To edit a post, hover over the post and click Edit.
- To clone a post, hover over the post and click Clone. Then, continue editing your post.
- To delete a post, hover over the post and click Action. Then, click Delete. In the dialog box, click Delete post.