Send a daily content update from a Google Sheet to LINE at a set time. It creates friendly text, builds a rich Flex message with images, and logs what was sent for tracking. Great for fitness and wellness teams that want steady engagement without manual work.

A schedule runs at 21:30 and reads pose data from Google Sheets. A short Code step formats the names. An AI model writes a clear intro message, then another pass polishes the tone. Another AI step builds the Flex Message JSON. Structured and auto fix parsers validate the JSON so the format is correct. The message text and the Flex JSON are combined and sent to LINE using an HTTP request. An AI Agent also cross checks names against a Google Sheets database. Each pose is then split and saved to a second log so you can count use and balance variety over time.

You need a Google Sheet with name, image URL, and link fields, an Azure OpenAI account, and a LINE Messaging channel with an access token. Expect daily outreach in minutes, stronger consistency, and clear logs for content rotation. This setup fits yoga studios, coaches, wellness apps, and any team that wants scheduled tips with images delivered on LINE.

• Scheduled send at a set time using a schedule trigger
• Reads item names, image links, and URLs from Google Sheets
• AI writes and rewrites a short friendly intro message
• Builds LINE Flex Message JSON and validates the structure
• Auto fixes JSON to prevent broken messages
• Combines text and Flex payload before sending
• Sends to LINE via HTTP request with header auth
• Logs the full message and each item to two Google Sheets
• AI Agent checks names against a Google Sheets database

• Reduce daily content prep from 30 minutes to 2 minutes
• Automate 100 percent of scheduled sends with no manual steps
• Cut message format errors by 90 percent using auto fix parsers
• Connect Google Sheets and LINE for a smooth content pipeline
• Track items sent so you avoid repeats and keep variety high

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Azure OpenAI and LINE Messaging API. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create Google Sheets OAuth2 credentials. Double click a Google Sheets node, choose Credential to connect with, click Create new credential, and follow the on screen steps. Grant access to the target Google account.
4. Open each Google Sheets node and set your Document ID and Sheet name. Replace any sample ranges with your own. Make sure your sheet has columns for name, image URL, and link. Keep the range consistent with your data.
5. Create Azure OpenAI credentials in n8n. Double click an Azure OpenAI node, choose Create new credential, then add your endpoint, deployment name, and API key from your Azure portal. Test the connection.
6. Set your model deployments on each AI node if needed. Keep the temperature settings or adjust them to match your tone.
7. In the LINE Developers console, create a Messaging API channel. Copy the Channel Access Token. In n8n, open the HTTP Request node for LINE, select or create an HTTP Header Auth credential, and set Authorization to Bearer YOUR_TOKEN.
8. In the request body, replace the to field with your user ID or test user ID. Use the LINE tools to get your user ID if needed.
9. Check the schedule trigger time and timezone. Adjust the hour and minute to your preferred send time.
10. Run the workflow once manually to test. Review the output of the Combine and Fix JSON nodes. If needed, paste the Flex JSON into the LINE Flex simulator to confirm the format.
11. Verify a 200 OK response from the LINE request. Then open your Google Sheets logs to confirm that a new row appears for the message and for each item sent.
12. Troubleshoot: If you see a 401 error from LINE, check the access token. If JSON errors appear, review the parser nodes and confirm your sheet fields are not empty. If rows fail to write, confirm the Google Sheet permissions and range settings.