Query ChatGPT and Save AEO Analysis to Google Docs

This automation begins by taking a user-provided prompt. It then opens a new browser session and navigates to ChatGPT, where it enters the prompt and waits for the AI to finish generating a response.

Once the response is complete, the automation intelligently extracts the full text. It then uses a second AI step to analyze this text, identifying and listing all mentioned companies, platforms, and citations.

Finally, it creates a new Google Doc and populates it with the results. The document includes the original prompt, the lists of identified companies and citations, and the full, unabridged response from ChatGPT, all organized with clear headings and formatting for easy reading.

Usage Ideas

• Market Research: Use a prompt like "List the top 5 competitors for Salesforce and their main product offerings" to quickly generate competitive analysis reports.
• Content Creation: Ask ChatGPT to "Write a 5-point blog post outline about the benefits of remote work" and get a structured starting point for your next article.
• Sales Preparation: Prepare for a client call by prompting: "Summarize the latest Q3 earnings report for [Company Name] and list key discussion points."
• Technical Learning: Speed up research with a query like "Explain the concept of Retrieval-Augmented Generation (RAG) and list key papers or articles on the topic."

Customization Ideas

This template is a powerful starting point for research and content generation. You can easily adapt it to your needs:

• Change the Analysis: The most powerful customization is changing what information you extract from the ChatGPT response. Instead of looking for companies and citations, you can instruct the AI to find key themes, write a concise summary, identify action items, or pull out any other data relevant to your work.
• Change the Destination: While the template saves to Google Docs, you can change the final step to send the report wherever you need it. Have the results emailed to you, posted in a Slack channel, or saved to another document service.
• Customize the Report: You have full control over the final document's appearance. You can change the title, edit the section headers, and adjust the text formatting to match your preferred style.
• Use a Different AI: You can modify the automation to interact with a different AI chat website if you prefer an alternative to ChatGPT.