AI Agents

Automate Google Sheets Data Analysis with AI Intelligence

26 nodes 337 146 Scheduled trigger
Download

Workflow Description

Scheduled automation that extracts data from Google Sheets, analyzes it using Gemini's AI capabilities, structures the insights intelligently, and publishes formatted results to Facebook automatically without manual intervention.

How it works

  1. 1.Trigger automation on a recurring schedule
  2. 2.Retrieve rows and data from your designated Google Sheets
  3. 3.Send data to Gemini for intelligent analysis and insights
  4. 4.Parse and structure the AI responses into formatted output
  5. 5.Publish analyzed results to your Facebook page

Use cases

  • Generate daily analytical reports on Facebook from spreadsheet metrics
  • Automatically summarize sales performance and statistics for social sharing

Requirements

  • Authorized Google Sheets connection with appropriate read access
  • Facebook app setup with Graph API credentials for posting
  • Active API key for Gemini language model access

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Google Sheets LLM Chain Gemini Output Parser Facebook

Details

Trigger Scheduled trigger
Nodes 26
Apps 5
Views 337
Downloads 146

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (26)

/

Scheduled Start: Check for New Posts

Schedule Trigger

#1

1. Get Next Post Idea from Sheet

Google Sheets

#2

2. Prepare Input Variables (Topic, Audience, etc.)

Set

#3

3a. Generate Content Concept (Gemini)

LLM Chain

#4

(LLM Model for Concept)

Gemini Model

#5

(Parse Concept JSON)

Output Parser Structured

#6

3b. Generate Image Prompt Options (Gemini)

LLM Chain

#7

(LLM Model for Prompts)

Gemini Model

#8

(Parse Prompts JSON)

Output Parser Structured

#9

3c. Generate Post Caption (Gemini)

LLM Chain

#10

(LLM Model for Caption)

Gemini Model

#11

(Parse Caption JSON)

Output Parser Structured

#12

4. Generate Image using Prompt 1 (Replicate Flux)

HTTP Request

#13

5. Prepare Data for Instagram API

Set

#14

6a. Create Instagram Media Container

Facebook Graph Api

#15

6b. Wait for Container Processing

Wait

#16

6c. Publish Post to Instagram

Facebook Graph Api

#17

7. Update Post Status in Sheet

Google Sheets

#18

Sticky Note

Sticky Note

#19

Sticky Note1

Sticky Note

#20

Sticky Note2

Sticky Note

#21

Sticky Note3

Sticky Note

#22

Sticky Note4

Sticky Note

#23

Sticky Note5

Sticky Note

#24

Sticky Note6

Sticky Note

#25

Sticky Note7

Sticky Note

#26

Similar Templates

AI Agent for Context-Aware Conversations with Database Data

30 nodes

Extract Gmail messages and save data to Airtable automatically

38 nodes

Summarize Gmail messages and send intelligent summaries automatically

19 nodes

Query Google Sheets data through intelligent chat conversations

19 nodes

Retrieve spreadsheet data and send to Slack using AI

12 nodes

Smart Google Calendar Assistant with OpenAI Integration

13 nodes