๐Ÿ’ฌ Send advice from three AI personas via LINE, Gemini, and Google Sheets

โšก 100 views ยท ๐Ÿ’ฌ Support Chatbots

Description

Who is this for

Anyone who wants a fun and practical AI chatbot on LINE. Great for people who enjoy getting advice from multiple angles โ€” whether they face work stress, personal dilemmas, or everyday decisions.

What this workflow does

When a user sends a text message to the LINE bot, the workflow:

  1. Parses the incoming LINE Webhook event
  2. Passes the message to Google Gemini via Basic LLM Chain
  3. Gemini replies as three distinct personas in a single structured response
  4. The advice is logged to Google Sheets for history tracking
  5. A Flex Message carousel is sent back to the user โ€” one card per persona, each color-coded

The three personas:

How to set up

  1. Create a LINE Messaging API channel and copy the Channel Access Token
  2. Set your n8n webhook URL as the LINE Webhook URL
  3. Create a Google Sheets spreadsheet with a sheet named advice_history and these headers in row 1: Timestamp, User ID, Message, Fortune Teller, Business Coach, Best Friend
  4. Open the Set config node and paste your LINE token and Sheet ID
  5. Connect your Google Gemini credential to the Google Gemini Chat Model node
  6. Connect your Google Sheets credential to the Save advice to Sheets node
  7. Activate the workflow and send a message to your LINE bot

Requirements

How to customize

๐Ÿ”— Nodes Used

Google Sheets, HTTP Request, Webhook, Basic LLM Chain, Google Gemini Chat Model

๐Ÿ“ฅ Import

Download workflow.json and import into n8n: Workflow menu โ†’ Import from File

๐Ÿ“– Importing guide ยท ๐Ÿ”‘ Credential setup