Facebook/Instagram Post Fetcher

What's Facebook/Instagram Post Fetcher?

FB/IG Post Fetcher by Keyword/Hashtag is a powerful Google Sheets add-on that automatically retrieves Facebook and Instagram post data based on your keywords or hashtags. It pulls post links, captions, dates, posts' engagement data directly into your Google Sheet or CSV, saving time and streamlining your workflow.

With this tool, your business team can quickly research organic content, enabling you to:

• Accelerate market analysis by accessing relevant posts in minutes

• Spot emerging trends before they go mainstream

• Identify valuable content to support proposals and campaign strategies

Step-By-Step Instructions

1. Install Social Media Data Fetcher

• Go to the Google Workspace Marketplace, search and install Social Media Data Fetcher for your Google account.

• Or directly install via this provided URL.

2. User Workflow

Step 1: Prepare the Google Sheet

• Open a new or existing Google Sheet.

• In the active tab, enter your search parameters:

  • Cell A2: Keyword

  • Cell B2: Post Type

  • Cell C2: Start Date

  • Cell D2: End Date

  • Cell E2: Choose Search by Keyword or Hashtag

• Template: [Template] Facebook/Instagram Post Fetcher by Keywords

Step 2: Run the Add-on

• Activate the FB/IG Post Fetcher via the Add-on button

• Select IG Posts/FB Posts

• Select "Start Fetching Comments"

Step 3: Authorize Access

• A prompt will guide you to grant access.

• Copy sheet-manager email address and share your sheet with that email as Editor permission.

Step 4: Fetch Comments

• Return to the sheet and click "Check again" (to confirm permission setup).

• Then click "Start fetching comment" once more to initiate the process.

Step 5: Wait for Results

• The add-on will process your request. Once data is ready:

  • Retrieved data includes:

    • Post URL

    • Post Caption

    • Post Date

    • Post Engagement data (Like, Comment, Video plays count, Video views Counts)

  • The data is written into your original Google Sheet with a new tab will be created named Result_of_[OriginalTabName].

  Example: Executing on Sheet1 → results appear in Result_of_Sheet1.

  • The original tab name does not change.

Tab Handling & Multiple Executions

• The add-on executes on the tab you have selected.

• You can run multiple executions in the same Google Sheet using different tabs:

  • Example: Execute on Sheet1 → then on Sheet2 → results appear in Result_of_Sheet1 and Result_of_Sheet2.

• If multiple jobs are submitted on the same tab while a previous job is still running, only the latest job executes, and earlier pending jobs are automatically canceled or replaced.

Limitation & Error Handling

• You can submit ONE keyword per execution, with a maximum of 300 posts retrieved per run.

• If the API returns an error or the keyword yields no matching results, an in-sheet notification will appear:

Example: "No posts found for this keyword"

The fetching process typically takes around 15–20 minutes, depending on system workload, the number of posts within the selected time range, and time zone differences.

🎥 Visual Walkthrough:

For a clear visual demonstration, watch the Facebook Post Fetcher by Keywords Instructional Video below:

https://drive.google.com/file/d/1cYY0tYAE389mVzbC0mpGkkAOYPX3ZUi7/view?usp=sharingdrive.google.com

And here is Instagram Post Fetchert by Keywords Instructional Video:

https://drive.google.com/file/d/1RY12KDjVaE3pYY726fQDnfCNvxRKxuHY/view?usp=sharingdrive.google.com