Automate Social Media Posts with Google Sheets & n8n

Effortlessly Automate Your Social Media Posts with Google Sheets & n8n

Say goodbye to manual scheduling and posting across multiple social media channels. With our tailored n8n workflow, you can seamlessly automate your daily social media posts using Google Sheets as your content calendar. Leverage the power of n8n combined with Google Sheets and the Meta Graph API to auto-publish engaging content to Instagram, Facebook, and LinkedIn, keeping your audience engaged effortlessly.

What this workflow does

This cutting-edge workflow operates every day at 19:00 in the Africa/Casablanca timezone, ensuring your content reaches your audience at peak times. Here's a detailed breakdown of how it functions:

• Reads from the “Content_Calendar” sheet in Google Sheets, filtering for items scheduled for today's date with a “pending” status.
• Formulates the post payload, building captions (including hashtags) and determining the type of content—image or Instagram Reel.
• Utilizes the Meta Graph API to create an Instagram media container for images and posts them to a Facebook Page. For Reels, the workflow creates an Instagram Reel container, processes it, and then uploads it as a video to a Facebook Page.
• Publishes the captioned image post to LinkedIn, ensuring consistent messaging across platforms.
• Updates each Google Sheets row, labeling them as “posted” with relevant timestamps and IDs upon success, or notes “failed” with specific error details if any issue arises.

Use cases

Perfect for n8n users and automation engineers seeking to optimize social media marketing efforts. Automate your company's weekly content calendar, streamline post scheduling for marketing campaigns, and ensure synchronized postings across popular platforms like Instagram, Facebook, and LinkedIn—all while tracking success in one cohesive sheet.

Technical details

• Platforms: Google Sheets, Instagram, Facebook, LinkedIn
• Nodes: Code, No Op, Wait, Switch, LinkedIn, HTTP Request
• Requirements: Google Sheets OAuth2 credentials, Meta app setup with access tokens for Instagram Business and Facebook Page posting