• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Social Media Examiner

Your Guide to the Social Media Jungle

  • 🔥 Free Newsletter
  • ⭐ FREE Web3 Course
  • 🗓️ Our Events
    • Social Media Marketing World (Mar 13-15)
    • Other Industry Events
  • 💡 Society
  • ⚙️ Tools
  • 🎙️ Podcasts
    • Social Media Marketing Podcast
    • Social Media Marketing Talk Show
    • Web3 Business Podcast
    • Our YouTube Channel
  • 🎯 Partner With Us
    • Podcast Sponsorship
    • Email Sponsorship
      • Email Newsletter
      • Dedicated Email Blast
    • Event Sponsorship
      • Social Media Marketing World
    • Tools Sponsorship
  • 👋 About Us
    • Our Story
    • Articles
      • Web3
      • Instagram Marketing
      • Facebook Marketing
      • YouTube Marketing
      • LinkedIn Marketing
      • TikTok Marketing
      • Expert Interviews
  • Search
  • Social Media Marketing World10th annual. Biggest industry event. Get the recordings!IMPROVE YOUR MARKETING

    How to Simplify the Publishing of Curated Content on Facebook With Free Tools

    by Suzi Whitford / April 25, 2016

    social media how toLooking for a way to simplify the process of publishing your curated content on Facebook?

    Want to schedule curated content posts and links to your own blog?

    By using If This Then That (IFTTT), Pocket, and Google Docs, you can create a cost-effective and time-saving workflow that will help you keep your Facebook page stocked with scheduled page posts.

    In this article you'll discover how to curate and schedule content for your Facebook page using three free apps.

    free tools to publish curated content on facebook
    Discover how to use free tools to curate and publish content on Facebook.

    #1: How to Set Up the Process With Free Apps

    As a new blogger or a small business on a budget, keeping your Facebook page updated with awesome posts can be time-consuming. Especially if you can't afford automatic schedulers like Buffer or Hootsuite.

    The steps below will show you how to build a queue of content to share with your audience for free.

    This setup will only have to be done once. These steps will show you how to use IFTTT to create a new line in a Google sheet from any site you save in Pocket. Then a few formulas will be created in the Google sheet to populate your queue of posts.

    You can then easily copy and paste the cell with the correct text into the Facebook scheduler. The image below shows an overview of the setup process.

    workflow setup process
    Setup process overview using Gmail, Pocket, and IFTTT accounts.

    First, create a Pocket account and add the Chrome browser extension, which quickly saves any website to Pocket with one click.

    install pocket extension
    Pocket features a slick browser extension for Chrome.

    If you don't already have one, create a Gmail account.

    In IFTTT you can make a connection, called a recipe, between Pocket and Google sheets. You can use a standard recipe to get started, or create one by following the steps below. It takes about five minutes.

    Search for the Pocket app and create a connection. Then click on My Recipes at the top of the window and click on Create Recipe. Next, click on “this.”

    create ifttt recipe
    Creating a recipe begins by clicking the blue “this” as shown.

    Type “Pocket” in the search field and click on the Pocket icon when it appears below the search field.

    3 Days of World-Class Training—Zero Travel!

    Social Media Marketing World

    Travel to Social Media Marketing World off the table? Get all of the great content at a fraction of the price with an On-Demand ticket.

    That’s full access to recordings of every keynote, workshop, and session—the ones people travel thousands of miles to see. Don't wait. Get your On-Demand ticket and enjoy actionable content that you can watch anytime, anywhere.

    GET YOUR ON-DEMAND TICKET NOW
    ifttt choose trigger channel
    Choosing a trigger channel is easy in IFTTT.

    Select Any New Item for the trigger. This trigger fires every time you add a new item in Pocket.

    ifttt choose trigger
    A specific event is a called a trigger, which launches the IFTTT recipe.

    After you've connected Pocket, click on “that” to connect to your Google Drive.

    ifttt set up action
    After setting up the Pocket trigger, it's time to click the blue “that.”

    In the search bar, type in “Google Drive” and select the Google Drive icon below when it appears.

    ifttt choose action channel
    An action channel connects to any of a wide variety of services.

    Now you need to choose a specific action item. For this method, choose Add Row to Spreadsheet.

    ifttt choose action
    Choose Add Row to Spreadsheet.

    Click on Create Recipe.

    ifttt create and connect
    Your recipe is ready to be saved, but it's not quite finished yet.

    Next, name the spreadsheet where your links from Pocket will be collected. IFTTT will create one in your Google Drive if needed.

    The formatted row shows the data that will be put into the spreadsheet. The AddedAt is the date the post is stored in your Google Drive. What's neat about this is that the ImageUrl shows up as a little preview image right in your spreadsheet!

    The Drive folder path is the location where this spreadsheet will be saved.

    If everything looks good, click Create Action.

    ifttt complete action fields
    Actions allow you to customize your IFTTT recipe further.

    You can test your IFTTT recipe whenever you click on Check Now.

    ifttt run recipe
    It's easy to test the functionality of your recipes.

    Tip: Multiple people can run the IFTTT recipe and populate the same Google sheet. This vastly speeds up how quickly you populate your queue.

    Manually populating a spreadsheet is unproductive. Creating a queue of posts for your Facebook page is easy with the one click of Pocket and the flexibility of Google Drive.

    #2: How to Easily Build a Queue of Posts to Schedule in Facebook

    Keeping your Facebook business page active and continuously posting great articles can be a full-time job! But delivering content to your audience is necessary if you want to grow your Facebook marketing strategy.

    Below are the steps to gather great posts, videos, or podcasts and queue them on Facebook.

    Tools Resource Guide

    Looking for something to make your life easier?

    Discover the tools we recommend to drive engagement, save you time, and boost sales across your entire marketing funnel or business.

    Whether you need help planning content, organizing social posts, or developing your strategy, you’ll find something for every situation.

    FIND YOUR NEXT FAVORITE TOOL

    You can use BuzzSumo or the Facebook Insights pages to help gather content your audience will like and engage with. Then use the Pocket Chrome extension to easily save the site. You can also use the Pocket iOS app or Android app to save articles when you're on the go.

    pocket save page
    Click and save any site quickly and easily.

    The recipe you created in IFTTT will automatically also place the date, headline, an image, and the URL into your Google spreadsheet. After saving a few websites, navigate to Google Drive to view your queue.

    google drive view queue
    It's alive! IFTTT and Pocket work seamlessly behind the scenes to build your Facebook page post queue.

    Find your spreadsheet by navigating to the IFTTT folder.

    google drive open ifttt folder
    Google Drive has a new folder called “IFTTT.”

    Then open the Pocket folder.

    google drive open pocket folder
    Next, click the Pocket folder.

    In the Pocket folder find your spreadsheet and open it.

    google drive open spreadsheet
    Finally, open the spreadsheet.

    When you expand the height of your rows you'll see the little preview images. Neat, eh?

    google drive view facebook queue
    When you expand the rows in Google Sheets, you can get a better look at the images.

    Instead of editing the data that Pocket and IFTTT send automatically, create a new sheet with the + icon at the bottom of the window. You can manipulate the data without interrupting the IFTTT recipe.

    google docs create sheet
    At the bottom of the sheet, click the + button to manipulate data without interrupting recipe functionality.

    This allows you to add headlines to the new sheet. Copy the data from Sheet1 by typing =Sheet1!A1 in cell A2.

    google docs titles and formula
    In cell A1 type =Sheet1!A1 to copy data from Sheet1.

    Select the bottom of the blue highlighted box and draw it across and down to copy all the cells from Sheet1. Drag the formula further down over blank cells to capture future data.

    google drive copy formula
    Click and highlight A1 and drag across the rows and columns, going past a few rows to capture future data.

    #3: Optimize Your Spreadsheet

    This is where the customization step comes in. Add a title to column G and column H. Write the description that will be shown with the post in Facebook in column G. Column H will be the cells to copy and paste into the Facebook scheduling tool. Next, string together the text from columns G, B, and F by typing type =concatenate(G2, ” “,B2, ” “,F2) in cell H2 in column H.

    google docs customize spreadsheet
    Concatenation will help you customize date to post.

    Replicate the formula by clicking on the blue box on the bottom right-hand corner of the selected cell and dragging it down. Column H will contain all of the posts you can schedule in Facebook.

    google docs content to schedule
    Column H becomes content you can schedule in Facebook.

    Tip: If you want to customize your spreadsheet further, you could add columns with time slots or character counts so you can use this queue for Twitter. Additionally, you could highlight the cells in different colors when you're done scheduling them in Facebook as visual indicators.

    #4: Schedule Your Queue of Posts for Facebook in Batches

    Batching saves time. By having your posts already queued, you can simply copy and paste post after post into your Facebook scheduler. This saves you time and keeps your Facebook page active.

    How? Copy any cell in column H and paste it into the status box on your Facebook business page. Click on the down arrow next to Publish and select Schedule. Select your desired date and time and schedule it to post in the future.

    schedule facebook post
    Copying, pasting, and scheduling a Facebook post.

    Even though the above method may look manual, it only adds one step of having to schedule within Facebook. Both automation tools and this method require you to populate them with content.

    workflow
    A winning workflow: find, build queue, schedule.

    Conclusion

    You're able to use free apps to schedule posts on Facebook with minimal time invested. Many beginning social media marketers would rather spend their money on a great hosting service and educational material.

    Additionally, the IFTTT recipe can be shared with team members who can populate the queue for your Facebook page or Twitter posts.

    What do you think? Have you used free apps to populate the queue for your Facebook page posts? What techniques work best for you? If you have any questions, please share them in the comments.

    publish curated content to facebook with free tools
    Tips on how marketers can publish curated content to Facebook with free tools.

    Get Your FREE Course: Web3 for Beginners

    Web 3 for Beginners

    Curious about Web3, but don't know where to start or who to trust?

    Introducing Web3 for Beginners, a course taught by Michael Stelzner, the founder of Social Media Examiner.

    Learn the basics of Web3 and apply it to your business with this FREE comprehensive course.


    CLICK HERE TO GET FREE ACCESS

    Tags: Facebook, Facebook Tools

    About the authorSuzi Whitford

    Suzi Whitford is an Industrial Engineer and blogger. She shares automation tips, productivity methods, and resource guides to grow your blog while raising a family.
    Other posts by Suzi Whitford Âť

    Get Social Media Examiner’s Future Articles in Your Inbox!

    Get our latest articles delivered to your email inbox and get the FREE Social Media Marketing Industry Report (39 pages, 50+ charts)!

    Industry Report Cover

    Worth Exploring:

    Facebook

    Marketing Help Explore More →

    Instagram

    Marketing Help Explore More →

    YouTube

    Marketing Help Explore More →

    Linkedin

    Marketing Help Explore More →

    Web3

    Marketing Help Explore More →

    Social Media Marketing Industry Report

    Get Free Report →

    Social Marketing Trends

    The data you've been missing!

    Need a new plan? Discover how marketers plan to change their social activities in the 14th annual Social Media Marketing Industry Report. It reveals what marketers have planned for their social activities, content marketing, and more! Get this free report now and never miss another great article from us. Join more than 400,000 marketers!

    Enter your email to get
    our free report:


    Footer

    Your Guide to the Social Media Jungle
    Copyright © 2023 Social Media ExaminerÂŽ
    All Rights Reserved. Terms of Use | Privacy Policy.

    Helpful Links

    • About us
    • Our content via email
    • Our podcasts
    • Our YouTube channel
    • Our live show
    • Our industry report
    • Sponsorship opportunities
    • RSS
    • Accessibility