Query ChatGPT and Save AEO Analysis to Google Docs
This automation queries the ChatGPT website with a specific question, analyzes the AI's response to extract key information like companies and citations, and then compiles the findings into a neatly formatted, new Google Document.
This template automates the process of researching a topic using ChatGPT and documenting the results. Here's how it works:
- Navigates to ChatGPT: The automation opens a cloud browser and goes directly to
chatgpt.com. - Submits a Prompt: It types a predefined question (which you can customize) into the chat input and submits it.
- Waits and Extracts: After waiting for the AI to generate a complete response, it extracts the full text.
- Analyzes Response: The automation uses a built-in AI model to analyze the extracted text, identifying and listing any mentioned companies and citations.
- Creates Google Doc: It connects to your Google account to create a new Google Document with a title formatted as "ChatGPT [Current Date]".
- Saves Report: Finally, it writes the extracted companies, citations, and the full original ChatGPT response into the new document, creating a permanent record of your research.
Usage Ideas
- Market Research: Ask for a list of competitors in a specific niche and save the analysis.
- Content Creation: Generate blog post ideas, outlines, or social media posts and save them for later.
- Sales Preparation: Research a prospect's company and industry to generate talking points for a sales call.
- Learning and Development: Ask for explanations of complex topics and save the responses to build a personal knowledge base.
- Recruiting: Research a candidate's prior companies to prepare for an interview.
Customization Ideas
This template is a great starting point for any AI-driven research task. You can easily customize it to fit your specific needs:
- Change the Question: You can modify the prompt sent to ChatGPT to research any topic you can imagine.
- Customize the Analysis: Instead of looking for companies and citations, you can instruct the automation to extract summaries, key takeaways, technical terms, or any other information from the AI's response.
- Change the Destination: While it saves to Google Docs by default, you can have the final report sent to a Slack channel, delivered via email, or saved to another connected service.
- Format Your Report: The structure and content of the final document are fully customizable. You can change the title, add your own headers, or re-order the sections to create the perfect report.
- Use a Different AI: You can point the automation to a different AI chat website if you prefer.