The Bottom Line:
- Connect Make.com to Google Docs, Google Drive, and ChatGPT API to automate podcast creation
- Set up a system prompt in ChatGPT to generate podcast content based on Google Docs input
- Configure Google Drive to search for and create new files daily for the podcast episodes
- Ensure proper API connections and authentication between Make.com, Google Cloud, and ChatGPT
- Run the Make.com scenario to automatically generate daily podcast episodes with AI-powered content
Setting Up Your Google Docs and Connecting to Make.com
Connecting Your Google Docs to Make.com
To begin, you’ll need to create a connection between your Google Docs and Make.com. Click on the “Add Module” button and select the ChatGPT connection. You’ll be prompted to create a new connection by providing your ChatGPT API key. Navigate to the ChatGPT platform, find the “API Keys” section, and generate a new key. Copy this key and paste it into the connection setup in Make.com. Once the connection is established, you’ve successfully linked your Google Docs, Make.com, and ChatGPT.
Configuring ChatGPT Settings
With your ChatGPT connected, proceed to select the “ChatGPT Turbo 16k” model. Next, focus on the “Messages” section, which determines the input ChatGPT will receive. Open the messages and create three roles: system, user, and assistant. The system role is where you provide the prompt instructing ChatGPT on what to do. The user role specifies what ChatGPT should read, which in this case, is the text content from your Google Docs. Finally, set the max tokens to 500 to ensure smooth processing.
Linking Google Drive and Setting Up File Search
The next step is to link your Google Drive to search for files. Select the “Google Drive” module and choose “Search for a file or folder.” If you encounter any issues during the connection process, you may need to enable the Google Drive API in your Google Cloud environment. Create a new project, navigate to the API library, and enable the Google Drive API. Then, set up the OAuth consent screen by adding the necessary domains (make.com and integromat.com) and scopes. Finally, create an OAuth client ID, add the authorized redirect URIs from Make.com, and use the generated client ID and secret to complete the Google Drive connection in Make.com. Configure the file search settings to look for files with specific naming conventions based on the current date.
Integrating ChatGPT API for Automated Content Generation
Configuring ChatGPT Messages
In the ChatGPT module, you’ll need to set up the messages that ChatGPT will receive. Click on the “Messages” section and create three roles: system, user, and assistant. The system role is where you provide the prompt that instructs ChatGPT on what to do. This prompt can be created by you or sourced from helpful resources, such as other YouTube channels dedicated to ChatGPT automation. The user role is where you specify the input that ChatGPT should process, which in this case, is the text content from your linked Google Docs. To ensure smooth processing, set the max tokens to 500.
Connecting Google Drive and Resolving API Issues
To enable file searching within your Google Drive, you’ll need to link it to your Make.com scenario. Select the “Google Drive” module and choose the “Search for a file or folder” action. If you encounter any issues during the connection process, you may need to enable the Google Drive API in your Google Cloud environment. Start by creating a new project and navigating to the API library. Enable the Google Drive API and set up the OAuth consent screen by adding the necessary domains (make.com and integromat.com) and scopes. Create an OAuth client ID, add the authorized redirect URIs from Make.com, and use the generated client ID and secret to complete the Google Drive connection in your Make.com scenario.
Creating and Populating Google Docs with Dynamic Content
The final step in the automation process is to create a new Google Docs file that will be populated with the generated content from ChatGPT. Use the “Create a Document” action in the Google Docs module and set the document title to include the current date. This dynamic naming convention ensures that a new document is created each day without the need for manual updates. In the document content, include a welcome message and the current date using the available date formatting options. To incorporate the generated content from ChatGPT, use the “Choices” option and select the “Message from Content” field. This will insert the AI-generated text into your document. Remember to specify the folder path where the document will be saved and click “Save” to apply your changes.
Configuring Google Drive and API Credentials
Setting Up Google Cloud Project and Enabling APIs
To resolve any connection issues between Make.com and Google Drive, you’ll need to set up a new Google Cloud project. Navigate to the Google Cloud Console and create a project named “Make Automation.” Once the project is created, go to the API library and enable the Google Drive API. This will allow Make.com to access and interact with your Google Drive files.
Configuring OAuth Consent Screen and Credentials
After enabling the Google Drive API, you’ll need to configure the OAuth consent screen. In the Google Cloud Console, go to the “OAuth consent screen” section and set up an external user type. Provide a name for your application, such as “Make Automation,” and add the necessary domains (make.com and integromat.com) to the “Authorized domains” list. Include your email address and save the changes.
Next, navigate to the “Credentials” section and create a new OAuth client ID. Select “Web application” as the application type and provide a name like “Make.” Under the “Authorized redirect URIs,” add the links provided by Make.com for Google Drive and other Google applications. These links can be found in the Make.com documentation. Once you’ve added the URIs, click “Create” to generate the client ID and secret.
Linking Google Drive and Setting Up File Search in Make.com
With the Google Cloud project set up and the necessary credentials obtained, return to your Make.com scenario. Click on the Google Drive module and open the advanced settings. Paste the client ID and secret you generated earlier into the respective fields. This will establish the connection between Make.com and your Google Drive.
To set up file searching, configure the Google Drive module to search for files based on a specific naming convention. Use the current date as part of the file name to ensure that the automation process looks for the correct file each day. Specify the folder path where the files will be located and adjust any other search parameters as needed.
Building Your Automation Scenario in Make.com
Creating Custom ChatGPT Prompts
In the ChatGPT module, navigate to the “Messages” section to define the prompts that will guide the AI’s content generation. Start by selecting the “System” role and enter a prompt that clearly instructs ChatGPT on the desired output. You can either create your own prompt or draw inspiration from other resources, such as YouTube channels dedicated to ChatGPT automation. Be specific and detailed in your prompt to ensure the generated content aligns with your expectations.
Integrating Google Docs and ChatGPT Output
To populate your Google Docs with the AI-generated content, create a new document using the “Create a Document” action in the Google Docs module. Set the document title to include the current date, ensuring that a new file is created each day automatically. In the document content, add a welcome message and the current date using the available formatting options. To incorporate the ChatGPT output, use the “Choices” option and select the “Message from Content” field. This will seamlessly insert the AI-generated text into your document.
Automating the Process and Testing
With all the components configured, it’s time to test your automation scenario. Save your changes and run the scenario. Make.com will execute each step, starting with the Google Drive file search, followed by the ChatGPT content generation, and finally, the creation and population of the Google Docs file. Monitor the progress and check the newly created document to verify that the content is generated as expected. If any issues arise, review your settings and make necessary adjustments. Once the automation is running smoothly, you can sit back and let Make.com and ChatGPT handle the daily content creation process.
Running the Automation and Generating Your Daily AI-Powered Podcast
Executing the Automation and Monitoring Progress
With your automation scenario fully configured, it’s time to put it into action. Click the “Run” button to initiate the process. Make.com will begin by searching for the specified file in your Google Drive based on the defined naming convention. Once the file is located, the contents will be passed to the ChatGPT module for processing. ChatGPT will generate the AI-powered content based on the prompts you provided in the “Messages” section.
Verifying the Generated Content and Making Adjustments
After ChatGPT generates the content, Make.com will create a new Google Docs file with the current date in the title. The AI-generated text will be seamlessly inserted into the document, along with the welcome message and date. Open the newly created file to review the content and ensure it meets your expectations. If you notice any discrepancies or areas that need improvement, revisit your ChatGPT prompts and make necessary adjustments. Fine-tuning your prompts will help you achieve the desired output more consistently.
Scheduling and Automating Future Runs
Once you’re satisfied with the generated content, you can set up your automation scenario to run on a daily basis. Make.com offers scheduling options that allow you to specify the time and frequency of your automation runs. Configure the schedule to align with your desired publishing timeline, ensuring that fresh content is generated and added to your Google Docs every day. With the automation in place, you can focus on other aspects of your work while Make.com and ChatGPT handle the daily content creation process seamlessly in the background.
