This n8n workflow automates the process of retrieving unpublished content from Google Sheets, generating a promotional message via AI, posting it to Google Business Profile, and then marking the content as published in the spreadsheet. The workflow is triggered on a scheduled basis, ensuring regular updates without manual intervention.
The process starts with a Schedule Trigger node, which initiates the workflow based on a set schedule (daily, hourly, etc.). It then retrieves an unpublished row from Google Sheets using the ‘Get Unpublished Row’ node, which contains new content to be published.
The retrieved content is sent to an AI Agent node, which uses an OpenAI chat model to generate a tailored promotional message or description for the content.
Next, the generated message is posted to a Google Business Profile via the ‘Post to GMB’ node, helping to automate local marketing efforts and enhance online visibility.
Finally, once the post is successfully published, the workflow updates the original Google Sheets row to mark it as published, preventing duplicate posting and maintaining accurate content status.
This workflow is ideal for businesses or content managers looking to automate their content distribution, streamline social media or local marketing posts, and keep their content calendar up to date with minimal manual work.
Reviews
There are no reviews yet.