Automation of social media posts with BulkPublish and Buffer

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.
buffer-home
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.
buffer-accounts
In Schedule section we can select for each social network the days and hours we want our content to be published.
buffer-schedule
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.
buffer-post

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.
csv-posts
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.
csv-twitter

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.
bulkpublish-home
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.
bulkpublish-upload
Second step is reviewing that the CSV file has been properly uploaded: we click on Next if everything is correct.
bulkpublish-review
Third and final step is to select the social network account we want to publish in and click on Send to Buffer.
bulkpublish-send-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.
buffer-imported-content

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
Rafa Roda – CEO of Yarr TV
Phone (+34) 629 436 321 Twitter @YarrTV
CONTACT US

Social TV for shops

Demo of a social television displaying Instagram and Facebook photos and Twitter tweets on the screens of a golf shop.

VIEW LIVE DEMO

Liked this demo?

CREATE YOUR YARR TV

Or try more demos:

Share this demo with the world!

Let’s boost your shop in social media

We develop solutions for your shop to be a success in social media, let’s talk!
Rafa Roda
Rafa Roda – CEO of Yarr TV
Phone (+34) 629 436 321   Twitter @YarrTV
CONTACT US

Social TV for hotels

Demo of a social TV displaying tweets and social media photos of a hotel on its screens.

VIEW LIVE DEMO

Liked this demo?

CREATE YOUR YARR TV

Or try more demos:

Share this demo with the world!

Let’s boost your hotel in social media

We develop solutions for your hotel to be a success in social media, let’s talk!
Rafa Roda
Rafa Roda – CEO of Yarr TV
Phone (+34) 629 436 321 Twitter @YarrTV
CONTACT US

Infographic on how to use Facebook at your bar

Discover how to use Facebook at your bar in 5 simple steps.

1. Create a Facebook Page

Login to Facebook with your personal account and click on Create page.

Select Local Business or place icon and Bar as a category: fill the required information about location and complete the page setup with contact details and opening hours.

2. Organize photos in albums

Facebook is great for publishing images correctly organized in albums, so create different sets of pictures for:

  • your weekly discounts,
  • your different product categories (Our red wines, Our imported beers),
  • your events, parties and themed nights (Brands events, Girls nights).

3. Use Events and Offers

Create Facebook Events from your page so people can join and invite their friends.

Facebook Offers is also a good way to attract new customers to your bar.

4. Share on your Page timeline

Share albums, events and offers in the timeline of your Facebook Page so your fans can share all this content on their profile and groups.

Use segmentation and highlighting features for targeting your posts to the right audience.

Get great ideas from Facebook at www.facebook.com/business/industries/retail.

5. Go beyond Facebook

Open to the world all the content generated in your Facebook Page:

Infographic

infographic-how-to-create-setup-use-facebook-page-bars-pubs

Liked it?

You may also like:

Let’s boost your bar in social media

We develop solutions for your bar to be a success in social media, let’s talk!
Rafa Roda
Rafa Roda – CEO of Yarr TV
Phone (+34) 629 436 321 Twitter @YarrTV
CONTACT US