We’re going to explain how to automate Twitter, Google+ and Facebook posts and being more productive by importing content in CSV format to Buffer using BulkPublish.
Buffer
Buffer is a super useful and simple tool to program our own posts or third-party ones to be published on your social networks.
We just have to register with our e-mail or our Twitter or Facebook account and connect our different social media accounts to Buffer, allowing its access. In our case, we add Twitter, Google+ and Facebook accounts of Yarr TV. With Awesome paid version we’ll be able to manage more social media profiles and add more posts from a single Buffer account.
In Schedule section we can select for each social network the days and hours we want our content to be published.
From Content section we can directly publish or select third-party contents in Suggestions. However, we’re going to see how to use BulkPublish to add contents selected from a spreadsheet.
Spreadsheet
We’ve prepared a Google spreadsheet titled Social media posts that can be found in the following link: https://goo.gl/Mrt892
- If we don’t have a Google account, let’s click on File > Download as > Microsoft Excel (.xlsx)
- If we own a Google account, we just sign in and click on File > Make a copy
In Posts sheet we can add new posts by numbering the cells of B column and writing the text for each of the social networks. Use Selected posts column to choose the contents to be published and their order: order shown in the image will result in a CSV file with posts 3, 1, 4 y 2, numbers that match with numbers in B column.
If we want to add emojis to Twitter posts we can use PiliApp.com and Symbols&Emoticons.com for Facebook (Google+ doesn’t properly support emojis in posts). We also recommend using an URL shortener: an interesting tool for this purpose is Sniply, that allows us to add custom messages to links.
Once posts have been selected in the right order, they’re ready to be exported to CSV files in Twitter, Google Plus and Facebook sheets. We access Twitter sheet and drag the formula from A and B columns if we’ve added more posts. Then, we just click on File > Download as > Comma-separated values (.csv, current sheet) and save in our computer the CSV file generated as Social media posts – Twitter.csv. We just repeat the same steps in Google Plus and Facebook sheets.
BulkPublish
BulkPublish is a tool still in beta that offers a free, simple and efficient solution to add content to Buffer from a CSV file generated from a spreadsheet.
We create a BulkPublish account using our e-mail and we connect our Buffer account allowing its access. Once connected, first step is importing previously generated CSV file with our posts. We just click on Upload your CSV and select in our computer the file Social media posts – Twitter.csv.
Second step is reviewing that the CSV file has been properly uploaded: we click on Next if everything is correct.
Third and final step is to select the social network account we want to publish in and click on Send to Buffer.
Once the process finishes, we access Buffer again and review that contents have been properly imported in Content section for the corresponding social network. In Buffer we can review again the contents before publishing, edit them or delete them. We repeat the same steps in BulkPublish to program content for Google+ and Facebook.
Conclusions
If we have contents that we frequently repeat in our social media posting calendar, taking some time to add them to a Google spreadsheet to be able to export them easily to CSV format and import them to Buffer using BulkPublish will significantly increase our productivity. Using these 3 solutions separately is very helpful, but combined they result in great savings of time.
Let’s talk!
We develop solutions to amplify your social media, let’s talk! |
Rafa Roda – CEO of Yarr TV |
(+34) 629 436 321 @YarrTV |
CONTACT US |
Great article,I have been working with both Bulkpublish and Buffer for 12 days and just now they have been able to explain how to get the file uploaded to BP. However, I upload using a text file because for some reason BP would not take any csv files for days.
Anyhow, I am stuck. I want to schedule tweets with pictures using BP going through Buffer, however when I upload the files they start going out in 2-hour time slots. Is there a way to schedul
I have been so impressed with the customer service within both companies but they still say they do not know each other hence why it has taken this long to get to this point.
I have been manually setting up Buffer every 5 minutes with graphics, there has got to be a way.
I am not designing a blog as this one you have here and any help will be added to the post with your company information and contact.Everyone is looking for this fix and I really want it known that these companies are awesome!
Can you help? Sherri
Hi Sherri!
Thanks for your comment ๐
We’ve been able to upload to BulkPublish posts with images without problems with the format that you can see here http://pastebin.com/3chBzu6Q
Regarding the scheduling, I suggest you to set it in Buffer: we only use BulkPublish to import CSV files.
Hope this helps ๐
Cheers!
Wow, what an amazing & helpful post! Huge high fives from the Buffer team! ๐
Thanks for your comment Bonnie ๐ We do love Buffer! If you ever need a social media wall for an event, just use Yarr TV Basic for free https://www.yarr.tv/create/yarr-tv/