<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Greg @ Business Automated on Medium]]></title>
        <description><![CDATA[Stories by Greg @ Business Automated on Medium]]></description>
        <link>https://medium.com/@business-automated?source=rss-e8d85d7ccf61------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*oh-TXmKtUhKvQDR2ffKu_Q.png</url>
            <title>Stories by Greg @ Business Automated on Medium</title>
            <link>https://medium.com/@business-automated?source=rss-e8d85d7ccf61------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 16:34:49 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@business-automated/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Airtable Interfaces and what to do with them the 2025 guide.]]></title>
            <link>https://business-automated.medium.com/supercharge-your-growth-with-airtable-mastering-interfaces-for-streamlined-operations-c17b1e8fa453?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/c17b1e8fa453</guid>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[data-management]]></category>
            <category><![CDATA[airtable-interface]]></category>
            <category><![CDATA[airtable]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Tue, 03 Jun 2025 16:24:36 GMT</pubDate>
            <atom:updated>2025-06-09T05:01:10.206Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*t0G03bZxZtswpIH6" /></figure><p>Hey there, growth-focused entrepreneurs! Greg from Business Automated! here, and today, we’ll be diving deep into a game-changing tool that you can use to optimise your business efficiency: Airtable Interfaces. In this article, I will be showing you how mastering Airtable Interfaces will unlock a whole new dimension of clarity and control within your business operations and workflows. Do head on over to our <a href="https://youtu.be/X_vu2JCLtiA">YouTube video</a> here for a clearer tutorial!</p><p>I’ll be honest. I myself was also skeptical about the effectiveness of Airtable Interfaces until I tried it myself. Trust me on this. From someone who’s never been a fan, I now use it for everything I do, and even encourage my own clients to start using this tool. This is especially so if you’re feeling the growing pains of scaling your own company — the information overload, scattered data over multiple dashboards, and the urgent need to track your business processes, operations and expenses.</p><p>You might be wondering. But Greg, I have so much to do — 24 hours in a day isn’t enough. Is Airtable Interfaces really that important? Yes, because as your business gradually expands, so does the data you have on hand. What starts as manageable spreadsheets can quickly become a tangled web of unnecessary numbers, dates and charts for you to crunch, costing you precious time and hindering decision-making processes. Regular Airtable views, while powerful, can still become overwhelming and inefficient for specific team needs if not managed well.</p><h3>Enter Airtable Interfaces: Your Personalised Project Management Tool Tailored to Suit Your Needs.</h3><p>Think of Interfaces as your own personalised dashboards. They allow you to curate specific views and functionalities regardless of the industry you’re in, presenting only the information that truly matters. This means less clutter, faster access to critical data, and a more efficient and cost-effective backend system.</p><h3>Imagine the Possibilities — 7 Different Business Case Studies</h3><p>Airtable Interfaces aren’t just about pretty dashboards. They can empower your teams with clarity and direction. In this tutorial, we’ll explore the incredible versatility of Airtable Interfaces and walk you through step-by-step on building customisable templates to suit your business needs.</p><h3>Business Case Study 1: Project Management Tracking</h3><p>Visualise your project timelines, track task progress, and manage resources with intuitive Gantt charts and Kanban views with the help of Airtable. Refer to the screenshots below to catch a glimpse of how they look like.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*soWDtUBQzUv1z1MGUGNilw.png" /><figcaption><strong><em>(Screenshot of Project Management Overview Dashboard in Airtable)</em></strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*H0cfqpcPHHUIvhdIlmDvvw.png" /><figcaption><strong><em>(Screenshot of a List View of My Tasks in Airtable)</em></strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eaQcmoi1GUZRyVm4czOI7A.png" /><figcaption><em>(Screenshot of a Kanban View in Airtable)</em></figcaption></figure><p>In Airtable, you can choose how you would like the data to be presented — be it a list, table, document, kanban, or timeline format.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YLzRtPMKPXtt2eyMgoREEA.png" /><figcaption><strong><em>(Screenshot of a Timeline View in Airtable)</em></strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eIoSv9kBn51m5zuP0VQ5tw.png" /><figcaption><strong><em>(Screenshot of a separate interface accessible only for management)</em></strong></figcaption></figure><p>There is also a separate interface accessible only for management. From this interface, you can take a look at the overview of the tasks that are in progress, weekly utilisation of employees, specific tasks allocated per employees etc.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/988/1*XL6EM4lrcxyMnJaxmQ5Xfw.png" /></figure><p>You can also include a directory that shows the team portfolio.</p><h3>Business Case Study 2: Resource Allocation Tracking</h3><p>Effortlessly manage your team members with Airtable. Track their availability, time-off requests, workload distribution, targets and progress all in one place.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8JLgBTCz-GNZg3glRs9Ttg.png" /><figcaption><strong><em>(Screenshot of a Resource Allocation dashboard template)</em></strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8U0gybfKghG931VvD21-Eg.png" /><figcaption><strong><em>(Calendar overview of team member’s availability in Airtable)</em></strong></figcaption></figure><p>With this dashboard template, you will be able to have an overview of your team’s schedule all in one place. You can even approve and reject the time-off requests submitted by your team members.</p><h3>Business Case Study 3: Sales CRM Tracking</h3><p>In Airtable, gain real-time insights into your sales pipelines, track individual and team performance against targets while managing your customer interactions effectively.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cHJuOWm0X4BIvOfokteU8Q.png" /><figcaption><strong><em>(Screenshot of the sales performance dashboard in Airtable)</em></strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rcfwofwh-4zciLUBRezadQ.png" /><figcaption>(Screenshot of how you can use the pivot tables to group opportunities)</figcaption></figure><p>Through the sales CRM dashboard, you can track individual performance against team targets, and manage customer interactions effectively. You can also use these data to analyse different opportunities and see what stage they are at.</p><h3>Business Case Study 4: Event Planning Dashboard</h3><p>When it comes to events, coordinate event roadmaps and logistics, manage vendor information, and track key milestones in a visually clear interface.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fe9-8Wwnj0dO5xIVNY9iiw.png" /><figcaption><strong><em>(Screenshot of the budget and expenses in event planner in Airtable)</em></strong></figcaption></figure><h3>Business Case Study 5: VC Deal Pipelines</h3><p>As an entrepreneur, your investors are essential stakeholders to your company. Manage your deals and investor outreach more easily with Airtable. You can even have their portfolios on hand should you need it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1016/1*6wHoMPRe10Wj6paLZ1BfbQ.png" /></figure><h3>Business Case Study 6: Finance Tracking Pipelines</h3><p>Review invoices, track payment statuses, and monitor budget allocations with dedicated financial dashboards all in one place.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dUVDl0Agy983-rvm1ANBkQ.png" /><figcaption><strong><em>(A screenshot of the finance review templates in Airtable)</em></strong></figcaption></figure><p>Airtable helps you to keep track of the relevant contacts, services they provided, and settle your payouts all with the click of a button. You can also attach invoices to the specific POC, so that you know it belongs to them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vxUDbCdM6OEUSvXBCFQvUg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ce7EqCP-0Qx5rUMCWR3bcA.png" /></figure><p>You can even have a separate page that shows the total amount for every contractor we are dealing with. This helps you to keep track of the invoices to ensure timely payment.</p><h3>Business Case Study 7: Quality Assurance Control for Factory Production</h3><p>It’s time for you to scrap paper memos and have a centralised system for quality checks and assurance all in one place. For example, for a factory producing furniture for kitchen such as table tops, legs and mounts, quality checks are a must-have before they reach the consumer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*olXSQMjEMb1tnPbeB8vQIg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*t7biozqFJ0ZGEcfTVlvjdg.png" /><figcaption><strong><em>(A screenshot showing a technical drawing of a table counter top)</em></strong></figcaption></figure><p>In Airtable, you can customise the field to display product measurements, name of the inspector responsible for quality checks, and the records to show that the quality assurance requirements are met. You can even add a technical drawing of the equipment so that your team is clear on what they need to do.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iTVxu1PycwthEI1ZJmz_lw.png" /><figcaption><strong><em>(A screenshot of the Quality Control Forms in Airtable)</em></strong></figcaption></figure><p>You can then fill in the details of the inspection in this form here. You can also have multiple inspectors to conduct the checks, and then input in the necessary data, and cross-check the inspection afterwards.</p><h3>Ready to Build? A Step-by-Step Tutorial for Your Factory Quality Assurance Interface.</h3><p>Now that you’ve seen and read what Airtable Interfaces can do, let’s get practical and start building a template designed for your needs. In this guide, we will be focusing on quality checks for factory production companies.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*e7RkY5VJDWiVbO74v35rGw.png" /></figure><h3>Step 1: Optimising your Base Template for Airtable.</h3><p>For this example, there is a list of equipment that the factory has utilised Airtable to monitor the quality assurance for.</p><p>When setting up the template, ensure that you have the filters set up for:</p><ul><li><strong>Table Legs:</strong> Track specific details like material, dimensions and mount type.</li><li><strong>QC Inspectors:</strong> A list of personnel responsible for quality checks. You can even input specific details about the inspectors in the records.</li><li><strong>QC Tops:</strong> You can customise to display detailed information about the countertops, including drawings with measurements, weights and formulas. You can also click into the bar to change the name of the formula, and feel free to add any additional tests or set ups in Airtable.</li></ul><h3>Step 2: Creating the Interface:</h3><p>Navigate to your Airtable base and click on <strong>Interfaces</strong> in the top left corner.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*F8bT7lQ-0AcYak2WmGk-3Q.png" /></figure><ul><li>Click on <strong>Create Interface</strong>.</li><li>Input the ID details of the product so that you can track.</li></ul><h3>Step 3: Building the Inspection View:</h3><p>Choose a layout, and then click on <strong>List</strong> view. Connect this page to the QC legs template that you made earlier by adding the product ID.</p><p>Add relevant filters by configuring them to show the required criterias. Add in the following drop downs after, e.g. QC Status 1 and QC Status 2.</p><p>Once you have added in the required filters, the formulated look up values will show up in the table. You can then adjust the formula by clicking into it as shown above.</p><p>Change the formula by adjusting the outputs you need as shown in the screenshot above. A tag will show up once the formula is correct. You can apply this for the height, width and dimensions and so on.</p><h3>Step 4: Building the Inspection View for QC Tops</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wIk2NIJEj8HPvTTOogRlDw.png" /></figure><p>Click Add page and name it “Tops Inspection.” Choose a list layout and then connect it to the <strong>QC Tops</strong> table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*25ID9Wusn-iqRC8qlPiIRQ.png" /></figure><p>Add in the filters so that it will show up in the screenshot above. Customise the displays to show relevant fields such as QC Status 1 and QC Status 2.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fDEDfhIw2HC4M3GAJ5jnhA.png" /></figure><p>Add in single drop downs along with the QC filters so that we are able to filter based on the inspections accordingly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AOcXgAlqQoCN5UQNPDALuw.png" /></figure><p>Select your action and open the <strong>Record Creation</strong> button.</p><ul><li>Click on <strong>Add Element</strong> and choose <strong>Button</strong>.</li><li>Label the button as <strong>New QC Check.</strong></li><li>Under <strong>Actions</strong>, select <strong>open a new record creation form</strong> and connect it to QC legs table.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iirvjmGJpUcx2nKpx5f0fQ.png" /></figure><p>We can also add in more information to the record so that it is easier to track the product accordingly. Do ensure that it is one record per time.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7aHgWlpm8fJFZNpIEEMRjA.png" /></figure><p>Do also add in the option to <strong>Open Record</strong> and make it full screen.</p><h3>Step 5: Creating a Detailed Inspection Form</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mdQQz6KXSOwdaGgfxYYT3g.png" /></figure><p>Click <strong>Add Element</strong> next and choose <strong>Record detail</strong>.</p><ul><li>Organise the information with groups and input in the necessary information so that you can have all the information you need in one place.</li><li>Add in a <strong>New Group</strong> and name it <strong>Product Details</strong>. Include editable fields like description, weight, and target weight.</li><li>Create a group for <strong>Quality Checks Results</strong> with dropdowns for QC Status 1 and QC Status 2.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5YDxJ-8-Tg6cn67Wr7U1Xg.png" /></figure><p>Change the record format to large.</p><ul><li>Create another block for dimensions, make them editable and the right layout.</li><li>Disable the comments as it may take up unecessary space.</li><li>Add in the name of the inspectors afterwards.</li><li>You can also make it optional to add new inspectors through a record.</li><li>You can publish it afterwards.</li></ul><h3>Ready to Take the Leap?</h3><p>By implementing this step-by-step guide, you’ll be well on your way to creating a powerful and intuitive Airtable Interface! Airtable is a crucial step in scaling your business effectively. By creating focused and user-friendly dashboards, you empower your teams with the right information at the right time, saving valuable time and reducing operational costs.</p><p>Why not take the first step today? Let’s explore the Interface feature in your Airtable base and start building!</p><p>Loved this guide? Stay tuned to our <a href="https://www.youtube.com/@BusinessAutomatedTutorials">YouTube channel here</a> for more tips and tutorials on how to automate and optimise your growing businesses. And as always, don’t forget to check out our <a href="https://www.business-automated.com/">website</a> here for ready-templates and in-depth guides.</p><p><strong>Watch the full video below:</strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FX_vu2JCLtiA%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DX_vu2JCLtiA&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FX_vu2JCLtiA%2Fhqdefault.jpg&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/f8fafa3ed8c5c10310200561874fa284/href">https://medium.com/media/f8fafa3ed8c5c10310200561874fa284/href</a></iframe><h3>Follow us for more</h3><p>Visit our Gumroad store for a <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">ready made blueprints</a> and as always do not forget to checkout our <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">Youtube Channe</a>l for all things related to automating your business!</p><p><strong>Business Automated</strong> is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Connect on BlueSky🟦⛅: <a href="https://bsky.app/profile/business-automated.com">https://bsky.app/profile/business-automated.com</a></p><p>Watch more on YouTube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c17b1e8fa453" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Analyzing Airtable Data with Custom GPT: A Step-by-Step Guide]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://business-automated.medium.com/analyzing-airtable-data-with-custom-gpt-a-step-by-step-guide-da821b7d3aa0?source=rss-e8d85d7ccf61------2"><img src="https://cdn-images-1.medium.com/max/1792/1*UGYMyoFIdHAhlJcI-IaOcQ.png" width="1792"></a></p><p class="medium-feed-snippet">How you too can build your own Junior Data Analyst to help you browse through your Airtable data!</p><p class="medium-feed-link"><a href="https://business-automated.medium.com/analyzing-airtable-data-with-custom-gpt-a-step-by-step-guide-da821b7d3aa0?source=rss-e8d85d7ccf61------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://business-automated.medium.com/analyzing-airtable-data-with-custom-gpt-a-step-by-step-guide-da821b7d3aa0?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/da821b7d3aa0</guid>
            <category><![CDATA[customgpt]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[chatgpt]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Thu, 30 Nov 2023 10:22:51 GMT</pubDate>
            <atom:updated>2025-05-23T11:27:55.288Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Automate Customer Support with GPT Assistants and Airtable]]></title>
            <link>https://business-automated.medium.com/automate-customer-support-with-gpt-assistants-and-airtable-443ca2915d16?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/443ca2915d16</guid>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[openai-api]]></category>
            <category><![CDATA[assistants-api]]></category>
            <category><![CDATA[openai]]></category>
            <category><![CDATA[airtable]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Tue, 21 Nov 2023 04:40:19 GMT</pubDate>
            <atom:updated>2025-05-23T11:27:40.569Z</atom:updated>
            <content:encoded><![CDATA[<p>Is this finally the time when your GPT assistant is able to know your company pricing and product features?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kdOugZGurThxQ9Hf6R4YUg.png" /><figcaption>AI Assistant generated by AI DALL.E v3</figcaption></figure><p>Customer support teams often find themselves answering the same questions repeatedly. With the latest OpenAI Assistants API, you can now leverage GPT-3 to automatically generate support responses based on your company’s internal knowledge. In this post, I’ll walk you through how to build a custom GPT assistant, connect it to your knowledge base, use it to create conversation threads, generate accurate replies, and integrate everything with Airtable and Gmail. Let’s get started!</p><h3>Set Up Your GPT Assistant</h3><p>First, we need to set up a custom GPT assistant within the OpenAI Platform <a href="https://platform.openai.com/playground">playground</a>. Here are the steps:</p><ol><li>Create a new assistant and give it a name.</li><li>Provide general instruction for the assistant. Know we will be overriding those later.</li><li>Select the gpt-4-1106-preview model since it&#39;s the best for assistants right now.</li><li>Enable the retrieval feature to connect your knowledge base.</li><li>You may enable “Code Interpreter” if you expect some data analytical tasks</li><li>Save the assistant and note down its ID (under the Name) — we’ll need this later.</li></ol><p>Now we have an empty assistant ready to be configured.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*appZTvK3c6z3Vn6n13yZSw.png" /><figcaption>Creating sample Assistant using the Open AI Platform backend</figcaption></figure><h3>Add Your Knowledge Base</h3><p>Next, we need to add our knowledge base documents that the assistant can reference when generating replies. For this demo, I’m using an Airtable base with pre-populated FAQs grouped into categories like pricing, features, etc.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VMlUPO02RWvaLbkuroCtEA.png" /><figcaption>Using Airtable as Knowledge Store</figcaption></figure><p>You can download the demo base from <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">my Gumroad page</a>.</p><p>To upload the FAQs into the OpenAI assistant knowledge store, I’m using a <a href="https://www.make.com/en/register?pc=from3mintech">Make.com</a> scenario with the following steps:</p><ol><li>Fetch all records from the Airtable FAQ table</li><li>Aggregate the questions, types, and answers into a Markdown file</li><li>Make an API call to OpenAI to upload the Markdown file and re-train the assistant on the new file</li><li>Delete any old FAQ files and remove old file from the assistant</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*u20gU4tnWJKbcj4zbeAk7g.png" /><figcaption>Upload file scenario in <a href="https://www.make.com/en/register?pc=from3mintech">Make.com</a>, download the ready made blueprints <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">here</a></figcaption></figure><p>If you have not used <a href="https://www.make.com/en/register?pc=from3mintech">Make.com</a> it is an API integration and automation tool — similar to <a href="https://zapier.com/">Zapier</a> but more flexible and pleasant to use.</p><p>The key steps are handled by these <a href="https://www.make.com/en/register?pc=from3mintech">Make</a> modules:</p><ul><li>create a new Markdown file</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZMjgnLvcz0uuGqwtI98gcA.png" /><figcaption>Using Text aggregator to create a mardown file (note that the output of Airtable for the field Answer is already in markdown format)</figcaption></figure><ul><li>Upload assistant file to OpenAI</li></ul><pre>POST https://api.openai.com/v1/files<br><br>Header:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot; <br>(Above authorization should be used in ALL API calls to open AI)<br><br>Body type &quot;Multipart/form-data&quot;<br><br>purpose=&quot;assistants&quot;<br><br>file=@hereGoesTheRawFile</pre><p>This translated to quite nice mapping in <a href="https://www.make.com/en/register?pc=from3mintech">Make</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/790/1*N1Gyb2XXe_7nE9VcWbLZtA.png" /><figcaption>Uploading file to assistant in OpenAPI</figcaption></figure><ul><li>If old file exist - delete it from Open AI</li></ul><pre>DELETE https://api.openai.com/v1/files/{{file id here}}</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Z5gxJnvORrjbVuBy2Mr3BA.png" /><figcaption>Delete file from Open AI with HTTP module in <a href="https://www.make.com/en/register?pc=from3mintech">Make</a></figcaption></figure><ul><li>remove file association from old assistant</li></ul><pre>DELETE https://api.openai.com/v1/assistants/{{your assistant ID}}/files/{{file ID}}<br><br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;  <br>#this header is needed for all assistants API<br>#operations, will likely change in the future</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ENFGYnMnutiDYjbCUH2sRw.png" /><figcaption>Remove association from the assistant</figcaption></figure><ul><li>Add new file to the assistant</li></ul><pre>POST https://api.openai.com/v1/assistants/{{assistant id}}/files<br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;<br><br>Body:<br>&quot;Content-Type: application/json&quot;<br><br>    {<br>      &quot;file_id&quot;: &quot;{{3.data.id}}&quot;<br>    }<br></pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fqlOlF0p-uXSucM0OVYQwQ.png" /><figcaption>Select POST method</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/978/1*XkCJebUWpH6pvhM7Cw-pcg.png" /><figcaption>Make sure to select “Parse response” = “Yes”</figcaption></figure><h3>Generate Reply Threads</h3><p>With the knowledge base connected, we can start generating replies by:</p><ol><li>Creating a new thread when a form is submitted</li><li>Adding the customer question as a message</li><li>Running the thread through the assistant</li><li>Repeatedly checking if processing is complete</li><li>Retrieving the generated response</li></ol><p>Here is what this looks like in the <a href="https://www.make.com/en/register?pc=from3mintech">Make</a> scenario:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SSrtiUrls45jEdocBHKtjw.png" /><figcaption>Scenario to create Open AI Assistant responses in <a href="https://www.make.com/en/register?pc=from3mintech">Make.com</a>, download the ready made blueprints <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">here</a></figcaption></figure><p>Some key points:</p><ul><li>What triggers sending of the mails and generating replies is an automation that sends record ID to <a href="https://www.make.com/en/register?pc=from3mintech">Make.com</a>:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*S8sf6iNiObGA2iluVUTPYQ.png" /><figcaption>Trigger based on “Generate reply” and “Send email”</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VdkBdEWiQyDxdjl3EdcR-g.png" /><figcaption>Make sure to send ID of the record as “recordId” to <a href="https://www.make.com/en/register?pc=from3mintech">Make</a></figcaption></figure><p>Read more below how to create script to send triggers from Airtable</p><p><a href="https://business-automated.medium.com/the-single-airtable-script-that-every-airtable-user-should-know-especially-no-coders-be2cafdf12a7">The single Airtable script that every Airtable user should know — especially no-coders</a></p><ul><li><strong>NEW! </strong>Create a new thread for each conversation. This is a new approach used by Assistants — different from completion API</li></ul><pre>POST https://api.openai.com/v1/threads<br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jUC9DJnM1HtycihljqIYkA.png" /><figcaption>Initiate new thread</figcaption></figure><p>Make sure to enable parse response to get the details of the response object and ID of newly created thread</p><ul><li>We construct a detailed user message prompt with instructions for the assistant</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/891/1*H0IBHUXL-Ve2YDUTAkU2fg.png" /><figcaption>User message prompt</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/855/1*jO4_mjN3gboee_YcB4rRhA.png" /><figcaption>Assistant instructions</figcaption></figure><ul><li>We need to add the user message to the thread</li></ul><pre>POST https://api.openai.com/v1/threads/{{thread ID}}/messages<br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;<br><br>Body:<br>&quot;Content-Type: application/json&quot;<br><br>{<br>      &quot;role&quot;: &quot;user&quot;,<br>      &quot;content&quot;: {{23.json}}<br>    }</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/962/1*2sxa8AB-yc0WnWE9RM2Q1A.png" /><figcaption>Adding message to a thread</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zkz_0D1ob0DdJnYj-kiveA.png" /><figcaption>including previously encoded JSON</figcaption></figure><ul><li>Run Assistant on your thread</li></ul><pre>POST https://api.openai.com/v1/threads/{{thread ID}}/runs<br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;<br><br>Body:<br>&quot;Content-Type: application/json&quot;<br><br>{<br>    &quot;assistant_id&quot;: &quot;Assistant ID&quot;,<br>&quot;instructions&quot;: {{34.json}} <br>  }</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/920/1*4Nquy5u6KkqVphwp5RQ1BA.png" /><figcaption>Include ID of your assistant and instructions</figcaption></figure><ul><li>The response doesn’t come immediately — we need to poll until processing completes</li></ul><pre>GET https://api.openai.com/v1/threads/{{thread ID}}/runs/{{run ID}}<br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CZnjrzvUq4_ZR2XAvkC31w.png" /><figcaption>We keep polling the run endpoint untill we get status=complete</figcaption></figure><ul><li>We extract the text from the returned message</li></ul><pre>GET https://api.openai.com/v1/threads/{{thread ID}}/runs/{{run ID}}<br><br>Headers:<br>&quot;Authorization: Bearer $OPENAI_API_KEY&quot;<br>&quot;OpenAI-Beta:  assistants=v1&quot;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/919/1*b80HH25u_CoYBo9JAg6PQw.png" /><figcaption>Once the thread has finished running you are able to download all messages associated with the thread.</figcaption></figure><p>The response of the Assistant will be on the top of the content array in the data object.</p><pre>{{33.data.data[].content[].text.value}}</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IXsXDbCgWhDl5-vlXa8IcQ.png" /></figure><p>Now we can take form submissions, create threads, and get automated responses!</p><h3>Connect Airtable and Gmail</h3><p>The last step is connecting everything to Airtable forms and Gmail.</p><p>When the “Send Email” button is clicked, record ID is passed via the trigger to the scenario that constructs a reply email using Gmail and sends it to the customer.</p><p>Final step is connecting Gmail. Note that we use Markdown component to convert Airtable markdown (rich field text) to HTML that can be accepted by Gmail</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hPxpP_IHEj5UWXBNSeFrJQ.png" /><figcaption>Settings for Gmail module in <a href="https://www.make.com/en/register?pc=from3mintech">Make</a></figcaption></figure><p>Now when a customer fills out the form, everything is handled automatically — from getting the generated response to sending a personalized email reply!</p><h3>Conclusion</h3><p>With the new GPT assistant API, you can easily create AI-powered customer support bots personalized to your business knowledge. Connecting it to Airtable and Gmail transforms the entire customer inquiry process — from submission to response.</p><p>Let me know if you have any other ideas for automating customer support with GPT! I’m excited to see all the new use cases as the assistant API matures.</p><p>Get the <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">Airtable base starter</a> and <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">ready made blueprints here</a>.</p><p>Watch the full walk through tutorial here:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FFA-51TUQvtg%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFA-51TUQvtg&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FFA-51TUQvtg%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/563efb54b5b5027c0e2ef3263a3dfbbf/href">https://medium.com/media/563efb54b5b5027c0e2ef3263a3dfbbf/href</a></iframe><p><strong>Useful readings:</strong></p><ol><li><strong>Open AI API docs</strong> — <a href="https://platform.openai.com/docs/api-reference/assistants">https://platform.openai.com/docs/api-reference/assistants</a></li><li><strong>Assistants API documentation</strong> — <a href="https://platform.openai.com/docs/assistants/how-it-works">https://platform.openai.com/docs/assistants/how-it-works</a></li></ol><p>Visit our Gumroad store for a <a href="https://businessautomated.gumroad.com/l/customized_email_assistant">ready made blueprints</a> and as always do not forget to checkout our <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">Youtube Channe</a>l for all things related to automating your business!</p><p><strong>Business Automated</strong> is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Connect on BlueSky🟦⛅: <a href="https://bsky.app/profile/business-automated.com">https://bsky.app/profile/business-automated.com</a></p><p>Watch more on YouTube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=443ca2915d16" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Access any website using OpenAI GPT API, Airtable & Make.com: A Step-By-Step Guide]]></title>
            <link>https://business-automated.medium.com/access-any-website-using-openai-gpt-api-airtable-make-com-a-step-by-step-guide-4ad62f9fb091?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/4ad62f9fb091</guid>
            <category><![CDATA[openai]]></category>
            <category><![CDATA[gpt]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[gpt-functions]]></category>
            <category><![CDATA[make]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Sun, 03 Sep 2023 10:47:46 GMT</pubDate>
            <atom:updated>2025-05-23T11:27:28.923Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*82Lre3Yf7nslJeKThywydw.jpeg" /></figure><p>The OpenAI GPT AI models have been trained on a significant amount of information, yet once the training is finished, these models stop having access to up-to-date data. That is why you often get inaccurate data or direct answer reminding you about the model cut-off date.</p><p>If you are using Chat GPT there are plugins like WebPilot or Web Requests that allow you to query websites and search internet for recent information. How would you do it with API though?</p><p>The solution that will enable you to supply the latest information to GPT models via API and make use of current knowledge is using the <a href="https://openai.com/blog/function-calling-and-other-api-updates">function feature</a> and <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> to execute those functions. In this in-depth guide, we will dive into how you can configure OpenAI GPT API to access and interact directly with any website.</p><p>Before we move ahead, be sure to check out the video for this guide available on our <a href="https://www.youtube.com/@BusinessAutomatedTutorials">YouTube channel here</a>.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FdVtAkBQv99Q%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DdVtAkBQv99Q&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FdVtAkBQv99Q%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/44a9d9a5b0e47238fd75abe41d13ecdc/href">https://medium.com/media/44a9d9a5b0e47238fd75abe41d13ecdc/href</a></iframe><p>Also, don’t forget to have a look at our <a href="https://businessautomated.gumroad.com/">Gumroad page</a> for downloading this scenario blueprint for <a href="https://airtable.com/">Airtable</a> and <a href="https://www.make.com/en?pc=from3mintech">Make.com</a>, available <a href="https://businessautomated.gumroad.com/l/access-web-with-openai-gpt-api">here</a>. You can also get a free account of Make <a href="https://www.make.com/en?pc=from3mintech">here</a>.</p><p>This guide will take you through the whole process step by step.</p><h3>Required software :</h3><ul><li><a href="https://airtable.com/">Airtable</a> account — (Pro needed to benefit from automations and scripts)</li><li><a href="https://www.make.com/en?pc=from3mintech">Make.com</a> — possible to start on free plan</li><li><a href="https://platform.openai.com/">OpenAI</a> account — provides some credits to start with</li></ul><h3>Step 1: setting up Airtable base</h3><p>The first step will be to set up Airtable base to create prompts and receive answers. It will contain 2 tables:</p><ul><li>Questions</li><li>Prompts</li></ul><p>The <strong>Question </strong>table contains the name of the question, relevant URL to research or free text query as well as linked field to select prompt.</p><p>We also have a Trigger Button to start the API request and 2 fields for raw data from the website accessed or query search and finally the GPT output</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xOwKDdxNg-1H2zDh1l3KSQ.png" /><figcaption>Questions table where we will ask questions and receive responses from Open AI</figcaption></figure><p>The Prompts table contains prompts that indicate action you would like to take with the result of your internet search, such as summarize/ rewrite content or event translate to another language. Using Prompt table allows to reuse longer frequently used prompts in an easy way. You can also easily experiment with different questions using different type of prompts and measure results.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/804/1*WaX0uixM3xHGj7X9RYPEKQ.png" /><figcaption>Prompt table in Airtable.</figcaption></figure><p>You can also download the base starter for free from <a href="https://app.gumroad.com/products/nypki/edit#content">here</a>.</p><h3>Step 2: Creating webhook and starting <a href="https://www.make.com/en?pc=from3mintech">Make</a> scenario with Airtable button</h3><p>Our objective will be to create a complete <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> scenario that will conduct necessary internet search, perform Open AI GPT API request and return data to Airtable.</p><p>In case you want to save time and do no want to go through all the steps yourself, you can also download the completed blueprint at a small fee <a href="https://businessautomated.gumroad.com/l/access-web-with-openai-gpt-api">here</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eYJwca1Dr3H-0MUz2GdoBQ.png" /><figcaption>Complete Make.com scenario</figcaption></figure><p>If you have not used <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> — it is a visual automation builder that greatly simplifies connecting to APIS. You can register for a free <a href="https://www.make.com/en?pc=from3mintech">here</a>.</p><p>We need to start the scenario with new webhook.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YtFVBUQw0icpr2oPF9Sovg.png" /><figcaption>Create new webhook in <a href="https://www.make.com/en?pc=from3mintech">Make</a> to use as trigger for scenario in Airtable</figcaption></figure><p>We will use this webhook (the URL) inside of Airtable in the button settings. Note that we are adding the dynamically the <strong>recordId </strong>as parameter at the end.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1OvAKcSm8aQ_2QlbUi2Y7g.png" /><figcaption>Using Webhook in Airtable to start an automation</figcaption></figure><p>Since the Button field in Airtable is nothing but a glorified hyperlink it will open a window for every click. I personally find this quite annoying so I always add a small trick to force the windows to automatically close, once scenario was successful.</p><p>To do that make sure you add a Webhook Response in your <a href="https://www.make.com/en?pc=from3mintech">Make</a> scenario.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/994/1*z83IqO2PaVTKDrD2oLpQeg.png" /><figcaption>This small chunk of code will automatically cause the window to close.</figcaption></figure><p>The code returned in the body is quite simple:</p><pre>&lt;!DOCTYPE html&gt;<br>&lt;html&gt;<br>&lt;head&gt;<br>    &lt;title&gt;Close Window&lt;/title&gt;<br>&lt;/head&gt;<br>&lt;body&gt;<br>    &lt;script&gt;<br>        window.onload = function() {<br>            var openedWindow = window.open(&quot;&quot;, &quot;_self&quot;);<br>            openedWindow.close();<br>        };<br>    &lt;/script&gt;<br>&lt;/body&gt;<br>&lt;/html&gt;</pre><h3>Step 3: Getting data from the internet</h3><p>In the next step we will connect to the internet to retrieve information from the page specified as URL inside of our Airtable. In case we decided to use a text query instead of actual URL — we will use that text and make a basic request to Google search, which will return us the first page of search results.</p><p>Note: Google search results are often country specific. In case of <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> the request is being made by a server that will be located either in US or EU depending on your setting preference indiciated when creating <a href="https://www.make.com/en?pc=from3mintech">Make</a> account.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/965/1*VQCQkWBDQGesRewHUeGjLw.png" /><figcaption>Retrieving content of website or search result from the internet.</figcaption></figure><p>The results return from this request will a full page in HTML — which contains way too much characters for Open AI GPT model to handle. This is why we need to get rid of HTML by converting the page to text. We will use for that <strong>Text Parser: HTML to text</strong> module built in to <a href="https://www.make.com/en?pc=from3mintech">Make.com</a>. Afterwards we are using one more <strong>Text Parser: Replace</strong> module to remove any links remaining in text except URL. We use here regular expression.</p><pre>\[(?!\/url\?.*).*?\] </pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/926/1*eNPEWtOWHntMkdATS5IbaQ.png" /><figcaption>Transforming website content to HTML and removing unnecessary links (e.g. links to images)</figcaption></figure><h3>Step 4: Inserting website content as context to GPT model</h3><p>Before we can make a request to Open AI with content of our website or query added as context, we will need to do a few transformation. We will be also executing a custom request using <a href="https://openai.com/blog/function-calling-and-other-api-updates">the new function feature</a> to Open AI API, this means we need to prepare the content of the request ahead.</p><p>To make sure that the text from the website does not break the JSON payload used in the HTTP request, we need to escape its content and convert it into JSON. We are using here native <a href="https://www.make.com/en?pc=from3mintech">Make</a> JSON module <strong>Transform to JSON.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/732/1*iNfDat1Zv45cpIlDRXGD3g.png" /><figcaption>Escaping long form text to use with JSON requests in <a href="https://www.make.com/en?pc=from3mintech">Make</a>.</figcaption></figure><p>We will all need to prepare all individual elements of chat GPT API request:</p><ul><li><strong>system </strong>prompt — In our case we just explain “You are a skillful web researcher”</li><li><strong>user </strong>prompt — here it is where we provide our prompt combined with URL or query, we are also encoding it later as JSON to avoid newlines breaking JSON structure</li><li><strong>search function — </strong>this is where we add a function definition so that GPT model can understand it is making and receiving <a href="https://openai.com/blog/function-calling-and-other-api-updates">function calls</a>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/694/1*i_YJSLAnIlpGzCRTnc1SaQ.png" /><figcaption>I am using <strong>Set multiple variables </strong>module to make adjusting those variables easier</figcaption></figure><h3>Step 5 Understanding the Open AI GPT functions</h3><p>You can read more about how to implement function calling in GPT API requests on <a href="https://platform.openai.com/docs/guides/gpt/function-calling">the Open AI function’s documentation page</a>. In this scenario we are using functions, however implemented with a shortcut. One could argue that you could also feed content of the website directly to the GPT model context without function calling at all. Yes, that would be true, but since it is relatively new feature I wanted to demonstrate this option, so that you can make this determination for yourself.</p><p>Here is example of value we provide in this scenario as <strong>search function</strong>:</p><pre>{<br>   &quot;name&quot;: &quot;Get_information_from_internet&quot;,<br>   &quot;description&quot;: &quot;Get necessary information from the internet&quot;,<br>   &quot;parameters&quot;: {<br>    &quot;type&quot;: &quot;object&quot;,<br>    &quot;properties&quot;: {<br>     &quot;q&quot;: {<br>      &quot;type&quot;: &quot;string&quot;,<br>      &quot;description&quot;: &quot;Search query, that will be passed to the search engine&quot;<br>     }<br>    },<br>    &quot;required&quot;: [<br>     &quot;q&quot;<br>    ]<br>   }<br>  }</pre><p>As you can see the function JSON contains following parameters:</p><ul><li>name — will be used by GPT model to reply which function to call.</li><li>description — this is essential for GPT model to understand in which context this function should be called</li><li>parameters — described using JSON Schema ( for more visit <a href="https://json-schema.org/">https://json-schema.org/</a>)</li></ul><p><strong>The shortcut</strong></p><p>In our particular use case, since we know that all prompts are asking GPT to something with content of the website, it would always reply to our HTTP request with following response ( showing the core part shortened for brevity):</p><pre>  {<br>   &quot;role&quot;: &quot;assistant&quot;,<br>   &quot;content&quot;: &quot;&quot;,<br>   &quot;function_call&quot;:  {<br>                 &quot;name&quot;: &quot;Get_information_from_internet&quot;,<br>                 &quot;arguments&quot;: &quot;{\n  \&quot;q\&quot;: \&quot;{{18.`URL or query`}}\&quot;\n}&quot;<br>                        }<br>  }</pre><p>This is basically a request from Open AI GPT to execute a function call. GPT is aware of functions, what they can do and can use their data, but is not able to make the function request on its own. That is why whenever it decides that a function should be called to provide more data — it will respond with:</p><ul><li>empty content property</li><li>function_call property — which contains name of the function and arguments to be passed to that function</li></ul><p>It is up to us to execute the function requested by GPT and provide response value of the function back to GPT.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/984/1*-u6MAksXibjjrxZwyB36ag.png" /><figcaption>Making direct HTTP request to GPT API</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ifvEZZ96mdfCDkK0lRXNBg.png" /><figcaption>As part of completion messages set we add expected response of GPT assistant and results of the function after</figcaption></figure><p>You can investigate the complete request body below.</p><pre>{<br> &quot;model&quot;: &quot;gpt-4-0613&quot;,<br> &quot;messages&quot;: [<br>  {<br>   &quot;role&quot;: &quot;system&quot;,<br>   &quot;content&quot;: &quot;{{11.system}}&quot;<br>  },<br>  {<br>   &quot;role&quot;: &quot;user&quot;,<br>   &quot;content&quot;: {{14.json}}<br>  },<br>  {<br>   &quot;role&quot;: &quot;assistant&quot;,<br>   &quot;content&quot;: &quot;&quot;,<br>   &quot;function_call&quot;:  {<br>                 &quot;name&quot;: &quot;Get_information_from_internet&quot;,<br>                 &quot;arguments&quot;: &quot;{\n  \&quot;q\&quot;: \&quot;{{18.`URL or query`}}\&quot;\n}&quot;<br>                        }<br>  },<br>  {<br>   &quot;role&quot;: &quot;function&quot;,<br>   &quot;name&quot;: &quot;Get_information_from_internet&quot;,<br>   &quot;content&quot;: {{10.json}}<br>  }<br><br> ],<br> &quot;functions&quot;: [<br>  {{11.`search function`}}<br> ],<br>&quot;temperature&quot;: 1<br>}</pre><p>You can see that we are making equivalent of 3 steps of chat conversation in a single call (user request, assistant making function request, function result returned to assistant).</p><p>GPT AI (as a proper REST API) is stateless, it doesn&#39;t know or care if you have made requests to it previously or not. Above request is a proper request that you would have to execute anyway, if you would make a prior request only with the user prompt.</p><p>The above shortcut basically removes one HTTP request in make. It will work well for this specific use case — getting information from internet. However if you are interested in making request to multiple functions or would like to give GPT freedom to decide which function to call — you might want to explore below video about making custom GPT functions with <a href="https://www.make.com/en?pc=from3mintech">Make</a> and Airtable.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FrJ2Oz6YIIxE%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DrJ2Oz6YIIxE&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FrJ2Oz6YIIxE%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/3a185bbfda1d04bfd00a20d063665707/href">https://medium.com/media/3a185bbfda1d04bfd00a20d063665707/href</a></iframe><h3><strong>Step 6: Saving the output of GPT API response to Airtable</strong></h3><p>Finally time to save the response from Open AI GPT API to Airtable. In our case we are using a simple <strong>Update a record </strong>Airtable module. The Record Id is being passed to the scenario during the initial button click and this is what we are using to identify record for update.</p><p>We are saving both — the raw website content — in order to have visibility about the content we have feed into the request, as well as the final content response from API</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/998/1*MlYiu8SriefZNwdiyEDjcA.png" /><figcaption>Saving responses from Open AI GPTAPI to Airtable</figcaption></figure><p>The scenario is starting with webhook, so it is of the instant type, meaning that whenever we press the trigger button in Airtable — <a href="https://www.make.com/en?pc=from3mintech">Make</a> will automatically pick up the signal and start execution. All you need to do is turn the scenario ON in <a href="https://www.make.com/en?pc=from3mintech">Make</a> and start your questions in Airtable!</p><p>Some of the examples where our clients have found it useful is:</p><ul><li>creating website summaries at scale</li><li>researching internet for new facts (not know to GPT based on training)</li><li>rewriting content for podcasts, social media and newsletters</li><li>finding and summarizing DIY recipes</li><li>finding social media handles</li><li>helping evaluate products and services</li></ul><p>What other ways you think you could use internet search together with the power of chat GPT API? Do let us know in the comments below, as well as what other use cases you might need.</p><p>Visit our Gumroad store for a <a href="https://businessautomated.gumroad.com/l/access-web-with-openai-gpt-api">ready made blueprints</a> and as always do not forget to checkout our <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">Youtube Channe</a>l for all things related to automating your business!</p><p><strong>Business Automated</strong> is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Connect on BlueSky🟦⛅: <a href="https://bsky.app/profile/business-automated.com">https://bsky.app/profile/business-automated.com</a></p><p>Watch more on YouTube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4ad62f9fb091" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The single Airtable script that every Airtable user should know — especially no-coders]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://business-automated.medium.com/the-single-airtable-script-that-every-airtable-user-should-know-especially-no-coders-be2cafdf12a7?source=rss-e8d85d7ccf61------2"><img src="https://cdn-images-1.medium.com/max/2600/1*2T8LuE0EpQeqFw_VFQkHtg.jpeg" width="3999"></a></p><p class="medium-feed-snippet">If you are connecting your Airtable to any external software using Zapier, Make.com or directly, you might want to use this approach to&#x2026;</p><p class="medium-feed-link"><a href="https://business-automated.medium.com/the-single-airtable-script-that-every-airtable-user-should-know-especially-no-coders-be2cafdf12a7?source=rss-e8d85d7ccf61------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://business-automated.medium.com/the-single-airtable-script-that-every-airtable-user-should-know-especially-no-coders-be2cafdf12a7?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/be2cafdf12a7</guid>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[zapier]]></category>
            <category><![CDATA[saas]]></category>
            <category><![CDATA[automation]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Thu, 08 Jun 2023 15:53:07 GMT</pubDate>
            <atom:updated>2025-05-23T11:26:45.090Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Automated document generation with Google Docs]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://business-automated.medium.com/automated-document-generation-with-google-docs-461778482d26?source=rss-e8d85d7ccf61------2"><img src="https://cdn-images-1.medium.com/max/1664/1*XCtAEBZL4vT7podWs1kCCA.png" width="1664"></a></p><p class="medium-feed-snippet">How to use Make.com and Google Docs templates to create simple automation pipeline for data from Google Sheet</p><p class="medium-feed-link"><a href="https://business-automated.medium.com/automated-document-generation-with-google-docs-461778482d26?source=rss-e8d85d7ccf61------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://business-automated.medium.com/automated-document-generation-with-google-docs-461778482d26?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/461778482d26</guid>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[make]]></category>
            <category><![CDATA[document-generation]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[google-docs]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Tue, 21 Mar 2023 16:14:05 GMT</pubDate>
            <atom:updated>2025-05-23T11:26:34.971Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[New — Airtable formula field with ChatGPT formula suggestions!]]></title>
            <link>https://business-automated.medium.com/new-airtable-formula-field-with-chatgpt-formula-suggestions-447447f9022b?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/447447f9022b</guid>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[code-completion]]></category>
            <category><![CDATA[chatgpt]]></category>
            <category><![CDATA[openai]]></category>
            <category><![CDATA[airtable]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Thu, 09 Mar 2023 08:12:52 GMT</pubDate>
            <atom:updated>2025-05-23T11:26:13.847Z</atom:updated>
            <content:encoded><![CDATA[<h3>New — Airtable formula field with ChatGPT formula suggestions!</h3><p>You will never have to worry about creating Airtable formulas again!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tlg9TKQP-IPBPFOWkbbUEA.jpeg" /></figure><p>Creating the right Airtable formulas can be a struggle, even for those well-versed in formulas (like us at Business Automated! 😁). Sometimes, the mental overhead of writing a new formula can be overwhelming 😉.</p><p>Whether you’re an Airtable newbie or expert, this new Chrome extension can help speed up the formula creation process. The new <a href="https://chrome.google.com/webstore/detail/airtable-hint-gpt/baiglioplcbfbnpnlbfjlkcfcllplkbg">Airtable Hint GPT Chrome extension</a> adds the long sought AI after feature that Airtable was missing — AI formula suggestions for Airtable formulas.</p><p>For newcomers, the tool can point you in the right direction and even provide complete formulas. For experts, having an AI robot to replace variables in nested IF statements can save a lot of time. Additionally, the tool can assist in rewriting formulas, such as converting IF statements to SWITCH statements.</p><h3>Overview</h3><p>The Airtable Hint GPT extension is based on Open AI’s GPT language model. This model uses deep learning techniques to generate human-like text based on a given prompt. Our extension utilizes this technology to help users create Airtable formulas more efficiently.</p><p>Once the user inputs a partial formula, the GPT model generates a list of possible completions based on the input. The user can then select the most appropriate completion for their needs. This saves time and mental effort by automating the formula creation process.</p><p>The ChatGPT feature of the Airtable Hint GPT Chrome extension takes the formula creation process to the next level. Rather than simply suggesting formula completions, ChatGPT allows users to chat with the GPT model to generate a formula. The user can simply describe the desired outcome and ChatGPT will generate the formula for them. This feature is perfect for those who may not be well-versed in formulas or are simply looking to save time.</p><h3>Use cases</h3><p>Any formula you are looking for — just describe what it supposed to do and press the green “Hint GPT” button.</p><p>Here are a few examples of prompt that could inspire you and a base to test it in:</p><h4>Base:</h4><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fairtable.com%2Fembed%2FshrrM8qIp5XtVvqgD&amp;display_name=Airtable&amp;url=https%3A%2F%2Fairtable.com%2FshrrM8qIp5XtVvqgD&amp;image=https%3A%2F%2Fstatic.airtable.com%2Fimages%2Foembed%2Fairtable.png&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=airtable" width="800" height="533" frameborder="0" scrolling="no"><a href="https://medium.com/media/49e40bf46e935e8700dd602745841a2a/href">https://medium.com/media/49e40bf46e935e8700dd602745841a2a/href</a></iframe><h4>Prompt ideas:</h4><ul><li>To create a visible warning with a stop emoji and a warning message if Status field is empty and show green check if status is OK, use the following formula:</li></ul><pre>IF(<br>  Status = BLANK(),<br>  &quot;❌ Warning: Please fill out the Status field&quot;,<br>  &quot;✅ Status is OK&quot;<br>)</pre><ul><li>To extract first name from the Project lead field, use the following formula:</li></ul><pre>LEFT({Project lead}, FIND(&quot; &quot;, {Project lead})-1)</pre><ul><li>To add 90 days to the adjacent date in the Current Period Start Date field in the Next Renewal Date Calc field, but only if there is data in that record, otherwise leave the Next Renewal Date Calc field blank, use the following formula:</li></ul><pre>IF(<br>  {Current Period Start Date},<br>  DATEADD({Current Period Start Date}, 90, &#39;days&#39;),<br>  BLANK()<br>)</pre><ul><li>To create a warning if the Subtask field contains the word MSA, use the following formula:</li></ul><pre>IF(<br>  FIND(&quot;MSA&quot;, Subtask),<br>  &quot;⚠️ Warning: Subtask contains the word MSA&quot;,<br>  &quot;&quot;<br>)</pre><ul><li>To convert the below IF formula to use SWITCH instead of IF:</li></ul><pre>IF(<br>  Status = &quot;Complete&quot;,<br>  CONCATENATE(&quot;😃 &quot;, UPPER(Name)),<br>  Name<br>)</pre><p>Use the following SWITCH formula:</p><pre>SWITCH(<br>  Status,<br>  &quot;Complete&quot;, CONCATENATE(&quot;😃 &quot;, UPPER(Name)),<br>  Name<br>)</pre><ul><li>To combine the Task with Project lead starting with “Task”, use the following formula:</li></ul><pre>&quot;Task &quot; &amp; Name &amp; &quot; - &quot; &amp; Project lead</pre><ul><li>To display the number of days between Due date and Kick off, use the following formula:</li></ul><h3>Caveats</h3><p>AI makes mistakes! Sometimes it will give you back formulas that are incorrect. You can realize that by the name of functions not being <strong>highlighted </strong>correctly. Airtable will also not let you save incorrect formulas. Sometimes formulas might look correct, but they produce unexpected results.</p><p>If your AI assistant cannot help you with your Airtable formulas, always try experts at the community forums: <a href="https://community.airtable.com/">https://community.airtable.com/</a> — official community</p><p><a href="https://air.tableforums.com/">https://air.tableforums.com/</a> — unofficial community driven by Airtable power users</p><h3>Installation</h3><p>Visit the <a href="https://businessautomated.gumroad.com/l/airtable-hint">download page on Gumtree</a> and download the extension.</p><p>Extension set up</p><ul><li>Open chrome://extensions</li><li>Enable developer mode in top right corner</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2IEBwDE85gYf-XZG" /><figcaption>Create developer mode to load extension</figcaption></figure><ul><li>Load the folder containing the extension in your browser. Click “Load unpacked” , enter the extension folder and “Select Folder”</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*uPOob6dqF5419Oq1" /></figure><ul><li>Now the extension is loaded and ready to use. It will show up whenever you open Formula field in Airtable</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*uHxJm2ZQARhm1Wd0" /></figure><ul><li>During the first use you will need to add your OpenAI token in side the settings</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*l77HZf_gEP4hEMQ-" /></figure><h4>Usage</h4><p>Type any request you have directly in the Airtable formula field and press “Hint GPT”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/658/1*I13TholCm8ssrVooSs-_Rg.png" /><figcaption>Use natural language to ask for formula. Explain in detail what fields it should use.</figcaption></figure><p>Once you get response from ChatGPT you will see the formula directly in the Formula field. You can ask to “Retry” to see if you will get different result (especially with higher temperature setting) or you can press “Back” to go back to the previous suggestion:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/664/1*6I_0wA2G4roSw9myKzDkog.png" /></figure><p>It is also possible to change the settings of the extensions with 2 parameters</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Q3tq_vGwLriScn0q8vfzXg.png" /></figure><p><strong>Temperature</strong></p><p>Default is 0.2. Setting temperature to 0 will make the answers mostly deterministic, while a higher number will create more randomness/variety in the responses.</p><p><strong>Completion mode and model</strong></p><p>Default completion mode and model is ChatGPT Completion Model. We recommend using ChatGPT completions (based on the “gpt-3.5-turbo” model). Regular GPT completions are based on “text-davinci-003” model. While both types yield similar results in most cases, the ChatGPT model is significantly cheaper to use.</p><h3>Final words</h3><p>This extension is a proof of concept that we have built to facilitate our work at Business Automated as well as help our clients. We would love to hear feedback from other Airtable users how this tool fits into their workflows!</p><p>Reach out to us on Twitter <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a> !</p><h3>Download the extension</h3><p><a href="https://businessautomated.gumroad.com/l/airtable-hint">Airtable formulas with ChatGPT - suggestions inside formula field - Airtable/Chrome extension</a></p><h3>Watch full tutorial on Youtube</h3><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FQEPW_A93_GI%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DQEPW_A93_GI&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FQEPW_A93_GI%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/22a5b73102a536f5a7eb832298dc39c8/href">https://medium.com/media/22a5b73102a536f5a7eb832298dc39c8/href</a></iframe><p><strong>Business Automated</strong> is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Connect on BlueSky🟦⛅: <a href="https://bsky.app/profile/business-automated.com">https://bsky.app/profile/business-automated.com</a></p><p>Watch more on Youtube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=447447f9022b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[You will never have issue with finding right images again.]]></title>
            <link>https://business-automated.medium.com/you-will-never-have-issue-with-finding-right-images-again-3e96d5fd1039?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/3e96d5fd1039</guid>
            <category><![CDATA[openai]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[image-generation]]></category>
            <category><![CDATA[dalle-2]]></category>
            <category><![CDATA[airtable]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Fri, 24 Feb 2023 13:53:28 GMT</pubDate>
            <atom:updated>2023-02-24T13:53:28.785Z</atom:updated>
            <content:encoded><![CDATA[<p>3 strategies I use to accelerate content creation, by creating AI art assets at scale using OpenAI Dall-e, Airtable and Make.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1zMOpkJs_B_Ba4zkGWixIQ.png" /><figcaption>Side by side comparizon of <a href="https://www.pexels.com/photo/woman-painting-outside-garden-542555/">photo by Jadson Thomas from Pexels</a> and AI generated image variation by <a href="https://openai.com/dall-e-2/">OpenAI Dall-e</a></figcaption></figure><p>OpenAI Dall-e is an artificial intelligence (AI) model developed by OpenAI which is capable of generating creative images based on text descriptions. This model has the potential to revolutionize content creation by allowing anyone to quickly generate high-quality images for their projects. With OpenAI Dall-e, users can input a text description of what they would like to create, and the AI model will generate a corresponding image. This can be a great time-saver for anyone who needs to create images for their content quickly and easily. Additionally, the model is capable of creating unique and creative images that may not have been possible to create manually. This opens up a world of possibilities for content creators who want to create unique and eye-catching visuals for their projects.</p><p>In this article, I will discuss three strategies I use to accelerate content creation by creating AI art assets at scale using OpenAI Dall-e, Airtable and Make. With the help of these tools, I am able to quickly generate high-quality images for my projects. Additionally, I have the ability to create unique and creative visuals that may not have been possible with manual methods. Finally, I will provide an example of the results of OpenAI Dall-e, so you can see the potential of this powerful AI tool.</p><h3>Tools needed</h3><p>The 3 tools I am using here are Airtable, <a href="http://make.com/">Make.com</a> (formerly Integromat) and OpenAI API. These allow content creators to quickly create and process large amounts of prompts, automate workflows and generate creative images.</p><h4>Airtable</h4><p>Airtable is a powerful cloud-based spreadsheet software that allows users to create and manage their data in an organized manner. It’s a great tool for content creators who need to create and manage large amounts of data quickly and easily. With Airtable, you can create custom databases with fields, share them with your team, and sort and filter data with ease. This makes it an ideal tool for content creators who need to quickly create and manage large amounts of data.</p><h4><a href="https://www.make.com/en?pc=from3mintech">Make.com</a> (formerly Integromat)</h4><p><a href="https://www.make.com/en?pc=from3mintech">Make.com</a> (formerly Integromat) is a powerful automation tool that allows users to quickly create automated workflows. This can be a great tool for content creators who need to quickly generate large amounts of data. With <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> , users can connect different services, such as Airtable and OpenAI, and create automated workflows that will generate images based on text descriptions. This can be a great time-saver for content creators who need to quickly generate images for their projects.</p><h4>OpenAI API</h4><p>OpenAI is an artificial intelligence (AI) model developed by OpenAI which is capable of generating creative images based on text descriptions. This model has the potential to revolutionize content creation by allowing anyone to quickly generate high-quality images for their projects. With OpenAI, users can input a text description of what they would like to create, and the AI model will generate a corresponding image. This can be a great time-saver for anyone who needs to create images for their content quickly and easily. Additionally, the model is capable of creating unique and creative images that may not have been possible to create manually. This opens up a world of possibilities for content creators who want to create unique and eye-catching visuals for their projects.</p><p><strong>Build faster!</strong> Get the templates and Make blueprint here:</p><p><a href="https://businessautomated.gumroad.com/l/generate-images-with-openai-dalle">https://businessautomated.gumroad.com/l/generate-images-with-openai-dalle</a></p><h3>Strategy 1: Images generated from prompts</h3><p>The first strategy I use is to generate images from prompts. This involves creating a database of prompts in Airtable, which can then be used to generate images with OpenAI. This is a great way to quickly generate high number of images for variety of prompts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-o--HO3Ko1OxC39du6vZuw.png" /><figcaption>Layout of Table to view multiple prompt generated images</figcaption></figure><p>The base is linked with <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> (formerly Integromat) and when Status is set to Generate, the scheduled make automation places call to Open AI API to create and retrieve images. Important — you need to also set number of images you want to generate in the column number.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ur_7p_Cw6eXpXjfIH4WkMw.png" /><figcaption>Scenario number 1 places call to Open AI API with a direct request and returns images</figcaption></figure><p>You can see details of the API calls and how to set up the custom HTTP call in the video linked at the end of this chapter.</p><p>Make sure that the prompt does not contain forbidden topics as per OpenAI policy as well as strange formatting artefacts which might case error in the response.</p><p>Watch full tutorial here:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FkG3tVIHPhRo%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DkG3tVIHPhRo&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FkG3tVIHPhRo%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/9a261d6c7313baa01354354abbf97273/href">https://medium.com/media/9a261d6c7313baa01354354abbf97273/href</a></iframe><h3>Strategy 2: Creating variations of an exiting image</h3><p>The second strategy I use is to generate variations of existing images. With OpenAI, users can input an image they already have, and the AI model will generate variations of this image. This is a great way to quickly generate a large number of variations of an existing image, which can be used to create more interesting visuals for content This opens up a world of possibilities especially if you have a good reference image.</p><p>In order to generate variations of an existing image using OpenAI, users need to provide the model only with an image. The requirements are:</p><ul><li>PNG format</li><li>Less than 4MB</li><li>Square aspect ration</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vYmuC5GRrawGlRjmAqjB-A.png" /><figcaption>Example of table in our base to create image variations</figcaption></figure><p>Similarly to step above we need set the number of images to create and set the Status field to “Generated”. Based on that the Search module in <a href="https://www.make.com/en?pc=from3mintech">Make.com</a> will look for all rows with that status and send data (original image) to OpenAI for processing. Once results are return, these are being uploaded to Airtable</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*E3pX05VCZD8X40KHhQzPSQ.png" /><figcaption>Make offers a no-code way of connecting to Open AI API to create image variations</figcaption></figure><p>For a full walk-trough and API call details you can watch this tutorial:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F0qEWMUOWjTg%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0qEWMUOWjTg&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F0qEWMUOWjTg%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/55ea65d508189bc85111a3060af6783d/href">https://medium.com/media/55ea65d508189bc85111a3060af6783d/href</a></iframe><h3>Strategy 3: Editing existing images</h3><p>The third strategy I use is to edit existing images. With OpenAI, users can input an image they already have, a mask indicating area to change, as well as a prompt describing the final scene.</p><p>Based on these 3 inputs the AI model will generate edited versions of the original image. There are a few important requirements about the input image and the mask:</p><ul><li>Both image and mask needs to be under 4 MB and in the PNG format</li><li>The images need to be square and have the same dimensions</li></ul><p>The mask is created by adding opacity (transparency) to original image. You can for example:</p><ul><li>Keep the central object in place and remove background. I use <a href="https://photokit.com/">https://photokit.com/</a> and cut out tool for that.</li><li>You can remove the object in the scene and keep the background</li><li>You can also selectively add partial opacity e.g. 50% which you want to partially modify. The higher opacity , the more of original image will be retained by AI.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UgQWWLwOsqhywN2B9lT1wA.png" /><figcaption>Edit image table structure</figcaption></figure><p>As the next step you need to select number of images you want to generate, it must be between 1 to 10. Change status to “Generate” and trigger Make scenario.</p><p>Make scenario contains 3 custom calls in the middle. First we are downloading the base image and mask and uploading this to Open AI.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*05CIzfqKvTKMAt7g-5NTGg.png" /><figcaption>Make scenario downloading the image and mask for OpenAI to create edits.</figcaption></figure><p>Make scenario downloading the image and mask for OpenAI to create edits.</p><p>You can see details of the API calls and how to set up the custom HTTP call in the video linked at the end of this segment.</p><p>Once Images are uploaded to OpenAI, Dall-e model processes them and returns files which are uploaded back to Airtable, while the Status is being changed from “Generate” to “Done”.</p><p>This model API is what is used for <a href="https://openai.com/blog/dall-e-introducing-outpainting/">Dall-e outpainting feature</a>, which allows to expand background of existing images and create bigger images of any shape and width. To build feature like that, you would need to execute multiple API calls with partial image from the edge of original picture and 0 opacity in places where the completion is supposed to happen.</p><p>I hope this scenario was useful for you. Let me know in comments how do you see these scenarios being used in your business and what AI features could help you!</p><p>Watch the full video tutorial of this scenarios here:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F1wMD1I0erDY%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D1wMD1I0erDY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F1wMD1I0erDY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/e99072a4bde003a1902fd935520f0261/href">https://medium.com/media/e99072a4bde003a1902fd935520f0261/href</a></iframe><p><strong>Build faster!</strong> Get the templates and Make blueprint here:</p><p><a href="https://businessautomated.gumroad.com/l/generate-images-with-openai-dalle">Generate and edit images with Open AI Dall-e 2 , Airtable and Make</a></p><p><strong>Business Automated</strong> is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Watch more on Youtube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3e96d5fd1039" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Getting all incoming emails directly into your Google Sheets]]></title>
            <link>https://business-automated.medium.com/getting-all-incoming-emails-directly-into-your-google-sheets-6793a54e1ce8?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/6793a54e1ce8</guid>
            <category><![CDATA[gmail]]></category>
            <category><![CDATA[make]]></category>
            <category><![CDATA[google-drive]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[email-automation]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Wed, 22 Feb 2023 09:06:07 GMT</pubDate>
            <atom:updated>2023-02-22T09:06:07.635Z</atom:updated>
            <content:encoded><![CDATA[<p>Capture Gmail emails with attachments in Google Sheets and Google Drive using simple <a href="https://www.make.com/en?pc=from3mintech">Make</a> automation scenario.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZPjvZyLNejxfb5WvvFmSjg.jpeg" /></figure><h3>Introduction</h3><p>By capturing your Gmail emails and their attachments directly in Google Sheets, you can save time and effort. With Google Sheets, you can easily organize your emails and quickly search through them, making it easier to find the information you need. Additionally, using Google Drive to store the attachments associated with your emails, you can easily access them whenever you need them. Setting up a <a href="https://www.make.com/en?pc=from3mintech">Make</a> automation scenario allows you to automate the capturing of your emails and attachments in Google Sheets and Google Drive, eliminating the need to manually transfer all of your data. This makes it easier to stay organized and save time.</p><p>About Make</p><p><a href="https://www.make.com/en?pc=from3mintech">Make</a> is an online service that helps you create automation scenarios to streamline your workflow. With <a href="https://www.make.com/en?pc=from3mintech">Make</a>, you can set up an automation scenario that captures your Gmail emails and the attachments associated with them in Google Sheets and Google Drive. This allows you to easily organize your emails, quickly search through them, and access the attachments associated with them whenever you need them. Setting up a Make automation scenario is easy, and it can save you time and effort.</p><h3>Overview of the scenario</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yzMQgxqWLF9yvUm-VjDCcA.png" /><figcaption>Simle <a href="https://www.make.com/en?pc=from3mintech">Make</a> scenario to link Gmail to Google Drive and Sheets</figcaption></figure><h3>Steps to set up Make Scenario</h3><ol><li>Log in to your <a href="https://www.make.com/en?pc=from3mintech">Make</a> account and click on the “Create a new scenario” button.</li><li>Click on the “Gmail” module in the left-hand side panel.</li><li>Select the “Watch emails” option from the Gmail module.</li><li>Enter your Gmail address and click the “Continue” button.</li><li>Set the criteria for the emails you want to watch for.</li><li>Add Iterator module as there might be multiple attachments</li><li>Add the “Google Drive” module to the right-hand side panel and select the “Upload File” option.</li><li>Connect the Gmail and Google Drive modules via iterator by dragging the arrow from the Gmail module to Iterator and from Iterator to the Google Drive module.</li><li>Select where you want to save the file</li><li>Add Array Aggregator and select the Iterator as source module. The Aggregator should collect Web View Links .</li><li>Add the “Google Sheets” module to the right-hand side panel and select the “Add Row” option.</li><li>Select the fields you want to capture from the Gmail module and enter the appropriate values in the Google Sheets module.</li><li>Click the “Run” button to start the Make automation scenario.</li></ol><p>You can read longer description of setting up Make for capturing emails in Google Sheet here Part 1: <a href="https://medium.com/geekculture/highway-to-efficiency-funnel-your-gmail-correspondence-to-google-sheets-88095a016ddb">https://medium.com/geekculture/highway-to-efficiency-funnel-your-gmail-correspondence-to-google-sheets-88095a016ddb</a></p><p>Here is also older article explaining how to capture attachments Part 2</p><p><a href="https://business-automated.medium.com/automagically-organize-and-store-your-email-attachments-on-google-drive-bd5bae29b158">https://business-automated.medium.com/automagically-organize-and-store-your-email-attachments-on-google-drive-bd5bae29b158</a></p><p><strong>Get the complete blueprint and Google Sheet Template here:</strong> <a href="https://businessautomated.gumroad.com/l/Save-Gmail-attachments-in-Google-Drive-and-Google-Sheets">https://businessautomated.gumroad.com/l/Save-Gmail-attachments-in-Google-Drive-and-Google-Sheets</a></p><p>You can also watch the full video walk-through here:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fei_xBP0LHJg%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dei_xBP0LHJg&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fei_xBP0LHJg%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/52cf1bad6200defe63706d81e8d6c3bf/href">https://medium.com/media/52cf1bad6200defe63706d81e8d6c3bf/href</a></iframe><p>Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Watch more on Youtube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6793a54e1ce8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Automate your letters with Google Docs — the only document templating tool you need]]></title>
            <link>https://business-automated.medium.com/automate-your-letters-with-google-docs-the-only-document-templating-tool-you-need-11fc04753867?source=rss-e8d85d7ccf61------2</link>
            <guid isPermaLink="false">https://medium.com/p/11fc04753867</guid>
            <category><![CDATA[mail-merge]]></category>
            <category><![CDATA[google-docs]]></category>
            <category><![CDATA[business-letters]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[make]]></category>
            <dc:creator><![CDATA[Greg @ Business Automated]]></dc:creator>
            <pubDate>Tue, 14 Feb 2023 11:18:32 GMT</pubDate>
            <atom:updated>2023-02-14T11:18:32.065Z</atom:updated>
            <content:encoded><![CDATA[<h3>Automate your letters with Google Docs — the only document templating tool you need</h3><p>Create automated business letters with dynamic data from Google Sheets with Google Docs templates and <a href="https://www.make.com/en?pc=from3mintech">Make.com</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pNP1_-RPzZiuFAUpdSVo5w.jpeg" /><figcaption>Boost your efficiency with easy to apply templates</figcaption></figure><h3>Introduction</h3><p>Creating business letters and envelopes can be a tedious, time-consuming task. Fortunately, there are tools available to make it much easier. With <a href="https://www.make.com/en?pc=from3mintech">Make (formerly Integromat)</a> and Google Docs, you can create automated business letters and envelopes from data stored in Google Sheets in an efficient, speedy manner.</p><p>Creating automated documents is also know as mail merge. Mail merge is a process used to create multiple documents at once using a template and data stored in a spreadsheet or database. It is an efficient way to produce multiple documents with the same formatting and content, but with personalized information. Companies such as Formstack, Docusign and Pandadoc all offer mail merge capabilities, allowing users to quickly generate personalized documents.</p><p>Using Google Docs is a great ( and cheaper) alternative to those solutions. It is an excellent way to save time and streamline the process of creating such documents. You can customize the output to best fit your needs, such as by adding company logos, signatures, and formatting. Additionally, you can easily store and access the documents you create via Google Drive, so they’re always just a few clicks away. With these tools, creating automated business letters and envelopes is no longer a daunting and time-consuming task — it’s quick and easy.</p><p>Software we are using here:</p><ul><li><a href="https://workspace.google.com/">Google Workspace</a> (Google Sheets, Docs and Gmail)</li><li><a href="https://www.make.com/en?pc=from3mintech">Make.com</a> account</li></ul><h4>Create Templates with Google Docs</h4><p>Using Google Docs, you can create templates for your business letters and envelopes, which can be customized to suit your needs. We are talking about regular Google Docs that you are familiar with. The key part is indicating the placeholders on the page that will be later replaced with data from your Google Sheets. We are using in this scenario curly brackets {{placeholder}} to mark the placeholders.</p><p>You can easily add text, images, and formatting to create professional-looking documents that look just the way you want them to. Since the template is stored online, you can also share it with others in your organization, ensuring that everyone is working from the same template. This saves time and ensures consistency across all of your documents.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kRe4Mzfv-x2M-EvgVFkAnA.png" /><figcaption>Example of envelope template</figcaption></figure><h4>Collecting data in google Google Sheets</h4><p>In order to generate automated business letters, you will need to collect the necessary data in a Google Sheet. This data will be used to populate the placeholders in the letters/ envelopes. For this example, we will be sending letters with order values to customers. You can follow this example and add any additional columns and custom placeholders to the letter.</p><p>To do this, you should create a Google Sheet with the necessary columns. These columns should include: Id, First Name, Last Name, Company Name, Address, City, Zip, State, Total Order Value, Send Letter?, and Status.</p><p>This data will be used as the source material for the next step of our automation process</p><h3>Automate Document Creation with Make</h3><p><a href="https://www.make.com/en?pc=from3mintech">Make (formerly Integromat)</a> is an automation platform that enables users to create automated workflows. With <a href="https://www.make.com/en?pc=from3mintech">Make</a>, you can easily connect different apps, web services, databases, and APIs together in order to create powerful automation workflows. In our example, you can connect Google Sheets and Google Docs to automate the creation of business letters and envelopes. Make will pull data from your Google Sheets and use it to populate the letter and envelope templates in Google Docs.</p><p>In Make a scenario is an automated workflow created with Make (formerly Integromat). It is a way to connect different apps, web services, databases, and APIs together in order to create powerful automation workflows. Make workflows are easy to set up and can be customized to meet your specific needs.</p><p>Each step is called a module. In our basic case we are using 5 modules.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LLnNoDEK9IGpzXix9lA2mQ.png" /><figcaption>Basic document merge scenario with Google Sheets, Docs and Gmail</figcaption></figure><h4>Reacting to data in Google Sheets</h4><p>The Make Google Sheets Search Rows module is used to search rows in a Google Sheet. It will search for rows based on the criteria you specify, such as a specific column value or date range. This module is useful for searching for specific data in your Google Sheet, such as rows that contain a certain value.</p><p>For example, you can use this module to find all rows in your sheet that contain “Send Letter?” = Yes. This will allow you to only send letters to those customers who you have manually selected that they should to receive a letter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jHp81sojAwiTrhqIXEFkTQ.png" /><figcaption>Set up of Make Google Sheet search rows module</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/891/1*MluEGyl11mdFLqaLIanIzQ.png" /><figcaption>We are also making sure that letter is not sent out once, by checking if Status field is empty.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Yys7TaBJPOAmPXfUOkR84g.png" /><figcaption>We are marking rows to send by placing “Yes” in column J</figcaption></figure><h4>Filling out Google Docs template with data</h4><p>The Make Create Document from Template module is used to create a new document from a template. It takes the data from the search rows module and uses it to populate the placeholders in your template. It then saves the new Google Sheet document. All you need to do is:</p><ul><li>find the template you want to use</li><li>match data with right placeholder</li><li>select location where to save the output</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3JeJivXZAUv88xiznT84yg.png" /><figcaption>The process is similar for both main document as well as envelope.</figcaption></figure><p>To avoid scenario running if there is no rows with data we are using filter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*c1RRzk1V2If_xQRCicaF9w.png" /><figcaption>This filter will stop execution if there are no data bundles.</figcaption></figure><h4><strong>Providing feedback to Google Sheet</strong></h4><p>Once scenario is successfully executed we need to provide feedback to Google Sheets that the row was processed and document generated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1010/1*iUiVdw7WKCckNHrnVMQ8sg.png" /><figcaption>We are doing this by adding word “Done” in the right column.</figcaption></figure><h4>Sending out email to conclude scenario</h4><p>At the end we are using Gmail module to send out notification to our team that the letters are ready to print out.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UU3Dx-LBhi4yjRgEJvbOWA.png" /><figcaption>Basic Gmail configuration</figcaption></figure><p>As an option we are also able to convert our Letter to PDF and sent it out as email attachement. You can achieve that by adding a Google Drive download module, toggling the “Show advanced settings” and selecting PDF format.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XRnVhT6UfyAghwO-B-WtOA.png" /><figcaption>Scenario version where you send out PDF as Gmail attachment at the end.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/982/1*mlggY3U5SFOSTKjGTrqXlg.png" /><figcaption>“Show advanced settings” and selecting PDF format.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1002/1*mhOhJSjb3_0PQujnaMjx2A.png" /><figcaption>Add attachment and use the auto-mapping to download module</figcaption></figure><h4>Scheduling</h4><p>Once you have completed setting up your scenario, you can easily schedule it to run on a regular basis. This ensures that your documents are always up-to-date and that you don’t have to manually run the scenario every time you need to create a new document.</p><p>Make offers several scheduling options that make it easy to set up recurring tasks. You can schedule a task to run once, daily, weekly, monthly, yearly, or on specific days of the week/month. You can also specify the time of day when the task should run.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/462/1*WH1JEyGXugdBp1G54BVmRg.png" /><figcaption>In our case we set scheduling to run every 15 min</figcaption></figure><h3>Conclusion</h3><p>Creating automated business letters and envelopes with Google Docs and Make is an effective method for producing documents with the same structure and content but with individualized information. You can easily set up templates using Google Docs and accumulate the required data in a Google Sheet, and then use Make to generate automated documents with dynamic data from your Google Sheet. Automating this process will save you time and effort, while guaranteeing uniformity across all of your documents.</p><p><strong>Get the templates and complete blueprints here:</strong></p><p><a href="https://businessautomated.gumroad.com/l/automated-business-letters">https://businessautomated.gumroad.com/l/automated-business-letters</a></p><p>Watch full description and walkthrough in this video:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FBqVPT0JRFxs%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DBqVPT0JRFxs&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FBqVPT0JRFxs%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/95a4d771719dffdfc3574702a8469096/href">https://medium.com/media/95a4d771719dffdfc3574702a8469096/href</a></iframe><p>Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at <a href="https://www.business-automated.com/">https://www.business-automated.com</a></p><p>If you like our tutorials — buy us a coffee☕: <a href="https://www.buymeacoffee.com/business">https://www.buymeacoffee.com/business</a></p><p>Follow us on Twitter🐦: <a href="https://twitter.com/BAutomated">https://twitter.com/BAutomated</a></p><p>Watch more on Youtube ️📺: <a href="https://www.youtube.com/c/BusinessAutomatedTutorials">https://www.youtube.com/c/BusinessAutomatedTutorials</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=11fc04753867" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>