top of page
Writer's pictureVP AnanthaKrishnan

Update AI Prompts in Make.com Automation with Airtable

Poster of Supercharge Your AI prompts with Airtable & Make

In today's rapidly evolving landscape of business automation and artificial intelligence, operational effectiveness is crucial for enterprise success. Managing AI prompts across multiple automation workflows has become increasingly complex, especially when these prompts are embedded directly into your business processes. For organizations implementing AI solutions, the challenges are clear: every time you need to modify a prompt, you must manually update it within the automation system, conduct thorough testing, and ensure the change doesn't disrupt other components of your integrated workflow. In this comprehensive guide, we explore an innovative approach to streamlined prompt management by leveraging Airtable's robust database capabilities, integrating it seamlessly with Make.com's automation platform, and implementing an intelligent prompt management system. This solution eliminates the need for manual workflow modifications while maintaining system integrity. Our step-by-step implementation guide demonstrates how to create a centralized prompt management system that efficiently stores and organizes system prompts, user prompts, and additional AI instructions within Airtable's structured environment. By utilizing Make.com's powerful automation features, you can create seamless integrations that connect these prompts to your existing automation workflows. Once this automated system is properly configured, any updates made to the prompts in your centralized database will automatically propagate throughout your automation ecosystem, significantly reducing maintenance time and minimizing operational risks.

Key Benefits:

  • Streamlined AI workflow management

  • Automated prompt updates

  • Enhanced system reliability

  • Reduced manual intervention

  • Centralized prompt control

  • Improved operational efficiency

Why Manage AI Prompts in Airtable? 

Managing AI prompts within automation directly can be problematic for several reasons. Every time you need to make a change, you must dive into automation, which can be parlous. Changes may break the workflow, especially if the prompts are used in multiple places across different automation. likewise, keeping track of different prompts for automation snappily becomes clumsy, leading to inefficiencies and implicit miscalculations.


Airtable, an important online database, offers a better result. By storing all your prompts in a centralized Airtable base, you can manage, update, and organize them efficiently. Using Make.com to integrate Airtable with your automation workflows allows you to pull these prompts stoutly, reducing the need to make changes within the automation itself. This streamlined approach ensures that all updates are applied automatically across your workflows, significantly enhancing effectiveness and reducing the threat of crimes. Step-by-step companion to Managing AI Prompts with Airtable and Make.com


In this section, we will guide you through setting up an Airtable base to store your AI prompts and also configuring Make.com to automate the process of importing these prompts as variables into your automation. By the end of this article, you’ll have a system that automatically pulls streamlined prompts from Airtable without demanding homemade intervention.


Step 1 Set Up an Airtable Base for AI Prompts


  • First, you’ll need to create a new base in Airtable to store your prompts. Each record in the base will represent a unique advisement, and you’ll have separate fields for the system, user, and additional prompts. Then’s how to set it up to create a New Airtable Base.

  • Log into Airtable and create a new base from Scrape. Name the base commodity descriptive, similar to the "AI Prompt Database." This base will store all of your AI prompts for easy access across your automation. Set Up the Table


    • Within the base, brand the dereliction table to "Prompts." This table will contain all of your prompt data, and you’ll create different fields for each prompt type, Name The name of the prompt, which you'll source in your automation.

    • System Prompt A long textbook field that stores the system prompt for the AI.

    • user Prompt A long textbook field for the user advisement.

    • Additional Prompt A long textbook field for the other guidance.


    Add Sample Prompts

    • Once the fields are set up, you can enter sample data to test the workflow. For example, create many records with different prompts and associate each with its system, user, and assistant advisement. Acclimate the row height if necessary to more view your prompts.

    • This setup organizes all your AI prompts in one place, allowing easy variations without demanding to interact directly with your automation.


Step 2 Configure Make.com to Import AI Prompts


Next, you’ll configure Make.com to stoutly pull the AI prompts from Airtable and use them in your automation workflows. Make.com allows you to connect apps and automate tasks without rendering, making it an ideal platform for this integration.


Produce a New Make.com automation

launch by opening Make.com and creating a new script. In this script, the first module will be an Airtable hunt, which retrieves the prompt data from the Airtable base you created in step 1.


Set Up Airtable Search Module

  • In the Make.com script, add an Airtable module and choose the "Search Records" action. You'll need to create a new connection to your Airtable account if you haven’t formerly connected Name the connection, for example, "AI Prompt Database," and authenticate your Airtable account.

  • Base select the AI Prompt Database you created before.

  • Table Choose the "Prompts" table.

  • Limit Set a limit for how numerous records to recoup. The dereliction is 10, but you can increase this if you have a large number of prompts.


Test the Airtable Module

Once the module is configured, run it formerly to make sure it retrieves the correct records. The affair should include all of the prompts you entered in Airtable, including the name, system, user, and other prompts. Step 3 Format the Prompt Data

Now that you’ve pulled the prompt data from Airtable, the next step is to format it so it can be used in your automation. This involves creating a structured format, similar to JSON, which you can pass to tools like ChatGPT. 


Use a Text Aggregator Module

In Make.com, add a "Text Aggregator" module. This module will combine all the data from Airtable into a single structured string, which can also be parsed as JSON. 


Configure the module as follows

Source Module Select the Airtable hunt module from step 2.

Row division Choose "Other" and set the division to a comma.


make the JSON Structure


In the Text Aggregator module, make out the JSON structure for the prompt data. This involves using Make.com’s erected-in functions, similar to upper( to convert textbook to uppercase) and replace( to replace spaces with underscores for formatting thickness). Then’s an example of how to make this structure JSON copy code. 

"PROMPT_NAME"{ 

"System" "System Prompt Text", 

"User" "user Prompt Text", 

"additional" "additional Prompt Text"


For each prompt, you’ll collude the fields from Airtable into this structure, ensuring that all prompts are formatted constantly. 


Parse the JSON Data

After creating the JSON string, add a "Parse JSON" module. This will allow you to convert the textbook string into a JSON object, which can also be used in a posterior automation way. In the JSON string field, simply collude the affair from the Text Aggregator module and wrap it in curled braces.


Step 4 Use the Cautions in ChatGPT

  • With the prompt data now in JSON format, you can use it in your ChatGPT automation. Then’s how to configure Make.com to stoutly fit the system, user, and other prompts into your ChatGPT module. 

  • Add ChatGPT Module 

  • In Make.com, add a ChatGPT module( or any other AI tool you're using). Choose the "create Completion" action, which generates a response grounded on the handed prompts.


Chart the Prompts

In the ChatGPT module, you’ll collude the system, user, and other prompts from the JSON object you created before. This ensures that the prompts pulled from Airtable are stoutly fitted into the ChatGPT module without demanding too hard-coding them.


Configure the Completion 

Set the parameters for the ChatGPT completion, including the model (e.g., GPT- 4), token limit, and any other applicable settings. Once everything is configured, save the automation.



Step 5 Automate Prompt Updates

  1. The real power of this setup lies in its capability to automatically modernize prompts across your automation. Once the Airtable database and Make.com automation are set up, any changes you make to the prompts in Airtable will automatically be reflected in your automation without making homemade updates. streamlining Prompts Simply go into your Airtable base, find the advisement you want to modernize and modify the textbook. The next time the automation runs, it'll pull the streamlined advisement from Airtable and use it in your workflows.

  2. No Need to Update Automation Since the prompts are stored in Airtable and imported stoutly, there’s no need to open the automation itself to make changes.


Step 6 Test the automation

Before completely planting the automation, run it manually many times to test its functionality. Make sure that the prompts are being pulled rightly from Airtable and that they're being counterplotted into the ChatGPT module as expected. However, set the automation to run on a regular schedule or spark it grounded on specific events (e, If everything works.g., new inputs or conduct).



Conclusion By managing your AI prompts in Airtable and automating their integration with Make.com, you can significantly improve the flexibility and effectiveness of your automation workflows. This approach eliminates the need to hard-code prompts directly into your automation, making updates quick and easy. Whenever you need to modify a prompt, simply update it in Airtable, and your automation will automatically use the new version. This streamlined process not only saves time but also reduces the risk of errors, allowing you to focus on more strategic tasks. By implementing this system of prompt management, you can ensure that your AI-driven automation runs smoothly and adapts efficiently to changes. To further enhance your automation skills, explore additional features and templates in Make. If you're interested in advancing your automation expertise, consider joining communities like Automation DIY, where you can learn from other automation enthusiasts. If you’re interested in building automated workflows or need guidance on Make.com, contact Growwstacks Automation Solutions at  www.growwstacks.com.





Comments


bottom of page