See llms.txt for all machine-readable content.

Back to Templates

Post scheduled social content from Google Sheets to LinkedIn, X and Instagram

Created by

Created by: Nida Sahar || nidasahar
Nida Sahar

Last update

Last update 7 hours ago

Categories

Quick overview

This workflow runs daily at 19:00, reads the next Scheduled post from Google Sheets, retrieves the matching media from Google Drive, publishes the post to LinkedIn, X, and Instagram via the Facebook Graph API, and then marks the row as Uploaded.

How it works

  1. Runs every day at 19:00 on a schedule.
  2. Reads the first row in Google Sheets where the Status column equals Scheduled.
  3. Searches a specified Google Drive folder for a file whose name matches the sheet’s File name value and downloads it.
  4. Posts the content to LinkedIn as an organization update with the image attached, using the sheet’s Links field as the post text.
  5. Posts the same Links text to X.
  6. Creates and publishes an Instagram image post via the Facebook Graph API using the sheet’s file url and Links caption.
  7. Updates the original Google Sheets row by setting Status to Uploaded so it is not posted again.

Setup

  1. Connect credentials for Google Sheets, Google Drive, LinkedIn, X (Twitter), and Facebook Graph API (Instagram Business/Creator).
  2. Select the target Google Sheets document and sheet in both Google Sheets nodes, and ensure columns exist for Status, File name, Links, row_number, and file url.
  3. Set the Google Drive folder to search and make sure file names in the sheet exactly match the media file names in that folder.
  4. Enter your LinkedIn organization ID (posting as an organization) and your Instagram Business account ID (Graph API node/target).
  5. Adjust the schedule time (triggerAtHour) if you want to post at a different hour.