Chat interaction with Search Console data using OpenAI and Postgres

• Interactively query website performance data from Google Search Console.
• Retrieve insights based on user-defined parameters like date range and dimensions.
• Store chat history for context in future interactions.

User sends a chat input through a webhook. Chat input is processed and relevant fields are set. AI Agent interprets the request and constructs an API call. Data is fetched from Google Search Console based on user input. Response is formatted and sent back to the user.

1. 1
   Import the workflow into your n8n instance.
2. 2
   Configure the Postgres and OpenAI credentials.
3. 3
   Set up Google Search Console OAuth credentials.
4. 4
   Deploy the webhook for receiving chat inputs.
5. 5
   Test the workflow by sending a chat input.