<?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[Botsheets - Medium]]></title>
        <description><![CDATA[Next Generation Spreadsheet Apps Powered by AI - Medium]]></description>
        <link>https://medium.com/botsheets?source=rss----3b1faf3efb66---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Botsheets - Medium</title>
            <link>https://medium.com/botsheets?source=rss----3b1faf3efb66---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Mon, 16 Nov 2026 12:03:49 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/botsheets" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How to create an AI chatbot for HR payroll analysis]]></title>
            <link>https://medium.com/botsheets/how-to-create-an-ai-chatbot-for-hr-payroll-analysis-ee94b7bee067?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/ee94b7bee067</guid>
            <category><![CDATA[analysis-tools]]></category>
            <category><![CDATA[hr-chatbot]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[customgpt]]></category>
            <category><![CDATA[chatbot-analytics]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Mon, 22 Jul 2024 19:18:27 GMT</pubDate>
            <atom:updated>2024-07-22T19:18:27.349Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aIhQbPtC2X4ri4yt6rMhnw.jpeg" /></figure><p>It’s no secret that you can leverage AI to streamline HR processes and significantly enhance productivity. One area where AI can make a substantial impact is payroll analysis.</p><p>In this tutorial, we’ll walk you through building an AI chatbot tailored for HR payroll analysis using a Google Sheets dataset connected to <a href="https://www.botsheets.com/">Botsheets</a>.</p><p>If you have an existing database and can sync, or manually import a CSV to Google Sheets, or you simply manage a spreadsheet with employee data natively in Google Sheets, that’s all you need to create an AI chatbot for yourself, or to share with your team.</p><h3>What You’ll Need</h3><ul><li>A Google Sheets dataset with employee payroll information. You can use this free <a href="https://docs.google.com/spreadsheets/d/1WYOxFHWhjyi2mbcK_lNlLaoZ8-R2KPtyDUin5zcBfhg/edit?usp=sharing">example dataset</a>.</li><li>A free <a href="https://www.botsheets.com/">Botsheets</a> account.</li></ul><h3>Step-by-Step Guide</h3><p>You don’t need any technical knowledge, or chatbot design experience to create an AI analysis chatbot. Once you have a dataset, you can simply connect it to a chatbot in a few simple steps.</p><h4><strong>1. Prepare Your Dataset</strong></h4><p>Start by creating your dataset in Google Sheets. A dataset is a collection of data that is organized into columns and rows. Column headers are data points and any rows of data below the headers are corresponding values. It provides structure to data that is easy for AI to understand, but also easy for you to manage.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ndl5j_o4-sppkqzQbV2ufQ.png" /></figure><p>You could have a small handlful of data rows, or several thousand rows of data in a single Google Sheet. When you connect a dataset in Google Sheets, your chatbot uses Google Sheets as a no-code database. There are a number of use cases for AI data analysis and where you could use a Google Sheet as a data source, but an employee dataset is a perfect example.</p><h4><strong>2. Set up a free account with Botsheets</strong></h4><p><a href="https://botsheets.com/signup">Sign in</a> with your Google Account with Botsheets. If you’re an agency, or plan for a team to access the Botsheets dashboard, you’ll want to create or use a Google Account that you can share with others, unless you feel comfortable providing someone else login access to your own Google account.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/866/0*xLn59d2S00yeSUx1.png" /></figure><p>You first provide basic access to your Google profile, but then Botsheets will request additional permissions.</p><p>Botsheets needs full permissions so it can not only read your data, but also write data to Google Sheets. Your organization’s data is private and secure so Botsheets will never access or use any file on your Google Drive unless you explicitly share it with Botsheets. All requested permissions are required and must be selected for Botsheets to work.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/814/0*PRww_lnUbpwE-NgG.png" /></figure><p>If you don’t select it and proceed, you’ll be prompted to provide permissions again. Once you provide the necessary permissions, you’ll be taken to our dashboard where you can create new chatbots, or access ones you have already created.</p><h4><strong>3. Connect Your Google Sheet to Botsheets</strong></h4><p>You’ll need to get a link to your Google Sheet so you can paste it into Botsheets and create the chatbot, so in Google Sheets, just click the <strong>Share </strong>button in the top right corner and click <strong>Copy Link</strong>. Note that if the Google Sheet was created with a different Google Account and stored on a different Google Drive than the one you signed into Botsheets with, you’ll need to change the share settings so that <strong>Anyone with the link</strong> can access it. Don’t worry, only Botsheets will access the sheet and your data is secure providing you don’t share the link publicly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ax4OCtOehGjfHJzZwCArKw.png" /></figure><p>Now, while there are two types of chatbots you can create with Botsheets, choose the <strong>Data Analysis</strong> bot.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zcgXp-HOF1qzPfys8IA_nA.png" /></figure><p>When you click the Create Chatbot button select <strong>Add Your Own</strong> from the dropdown menu and paste in the link to the Google Sheet. Then click the green <strong>Create Chatbot </strong>button.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cDvW0v7yH2Y4WKAeoxlEPg.png" /></figure><p>That’s it! Your chatbot is ready to test out with payroll analysis queries. Think of some example questions to guide your chatbot’s responses.</p><ul><li>“What is the tax code of John Doe?”</li><li>“How many hours did Emily Davis work last period?”</li><li>“What are the year-to-date earnings for Linda Clark?”</li><li>“What is the gross salary of James Taylor for the current pay period?”</li><li>“What is the PAYE liability for Sarah Wilson this month?”</li></ul><p>You can see here I just sent a message to rank employees by salary and the chatbot output a table:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*djBjiW0hqMl-heWcOQOGjA.png" /></figure><p>Here you can see that I asked it to plot the data from the table in a pie graph, but I only asked for the the top 10 otherwise the visualization would be quite messy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3lHIT0i4JHXLL9gFN5l2OA.png" /></figure><p>Botsheets will even give you easy access to the image so you can dowload it, or paste into a document such as a presentation. Just click the little arrow in the bottom right corner of the visualization and the image will open in a new browser window.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/1*SWATYu-uQR9YGGCEGskN_A.png" /></figure><p>If you want to change the visualization, just ask it to change it. Here I told the bot I wanted a bar graph and only to use blue bars.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*edhSpwb0n4u6GjXssc3TsQ.png" /></figure><p>Before deploying, or sharing your chatbot, thoroughly test it to ensure it accurately responds to queries based on the dataset. Use various test cases and scenarios to validate its functionality.</p><p>While the chatbot has a default greeting message, if you plan to share it with others, just customize the greeting message in <strong>Bot Settings &gt; Rules</strong></p><p>Here you can see that I added some example questions people accessing the chatbot might want to ask in order to get a response.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kxwCNLsVadO3-L2DucqoIA.png" /></figure><p>When you’re ready to share it, just click <strong>Share Bot </strong>in the left navigation and you’ll be presented with options to share a direct link, add a widget to the bottom right corner a webpage, or you can embed it directly in the middle of a page. You just copy the code snippet and share it, or paste it into your HTML if you’re publishing it within an existing website.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YfiskBZ0zSbDui1fn82B8w.png" /></figure><p>Utilizing our AI-powered chatbot to analyze payroll information for employees you’ll get valuable insights into your workforce. Our sample dataset includes detailed information on employees, such as:</p><ul><li><strong>Employee ID</strong>: A unique identifier for each employee.</li><li><strong>Name</strong>: The full name of the employee.</li><li><strong>Job Title</strong>: The job title or position of the employee.</li><li><strong>Department</strong>: The department where the employee works.</li><li><strong>Tax Code</strong>: The tax code assigned to the employee.</li><li><strong>Hours Worked (Last Period)</strong>: The number of hours the employee worked in the last pay period.</li><li><strong>YTD Earnings</strong>: Year-to-date earnings for the employee.</li><li><strong>PAYE Liability (Current Month)</strong>: The Pay As You Earn (PAYE) liability for the current month.</li><li><strong>Gross Salary</strong>: The gross salary for the current pay period.</li><li><strong>Deductions</strong>: Total deductions for the current pay period.</li><li><strong>Net Salary</strong>: The net salary after deductions for the current pay period.</li></ul><p>You can add your own datapoints as well. Remember though, just make sure that you have a row of column headers and at least one row of data. Avoid blank rows of data too.</p><p>Want to try it out? You can play around with our example <a href="https://botsheets.com/employee-database">here</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RbW4G_2N1FzFVE2NSExYhg.png" /></figure><h4>Conclusion</h4><p>Building an AI chatbot for HR payroll analysis can greatly improve your HR department’s efficiency. By following these steps and utilizing the provided dataset, you can create a powerful tool for analyzing and managing payroll information.</p><p>Feel free to reach out if you have any questions or need further assistance in setting up your AI chatbot! As you can see though, it’s quite easy so get started free at <a href="https://www.botsheets.com/">Botsheets.com</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ee94b7bee067" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/how-to-create-an-ai-chatbot-for-hr-payroll-analysis-ee94b7bee067">How to create an AI chatbot for HR payroll analysis</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Starter Kit (Messenger)]]></title>
            <link>https://medium.com/botsheets/starter-kit-messenger-c681268cd128?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/c681268cd128</guid>
            <category><![CDATA[manychat]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 06 Apr 2024 09:04:08 GMT</pubDate>
            <atom:updated>2024-04-06T09:04:08.096Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SALb4PZqdeaU-mcpmbk-jQ.jpeg" /></figure><p>This toolkit includes:</p><ol><li>A Manychat template (along withBotsheets Action app)</li><li>A Google Sheet template that communicates with the Manychat template</li></ol><p>Once you have made a copy of the Google Sheet, Installed our Manychat template, and received and stored your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a>, follow this guide.</p><h3>Share Access To The Google Sheet</h3><p>Assuming you have made a copy of the Google Sheet template for this Toolkit, you’ll need make the Google Sheet shareable so that Botsheets can read your data. Click the green share button at the top right corner of Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/490/1*V8RtXJPwfjmKiD2MQlsm6A.png" /></figure><p>Change the share settings in Google Sheets so that <strong>Anyone on the Internet can view your sheet</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Svq28nG__WDaNBGmdXCGw.png" /></figure><p>Don’t worry as only those with the link can access the sheet data. Copy the link to your clipboard. You’ll give that read access to your Manychat bot.</p><h3>Set up the Manychat Action app</h3><p>When you install our Manychat template, it comes bundled with our Manychat Action app. This is where you’ll store your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a> and a link to your Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BCb2SnWZYVvn6REd.png" /></figure><p>You can access the Botsheets app through Manychat Settings &gt; Apps. Select the Botsheets app and add your Botsheets Key and shareable link to your Google Sheet</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*eMU7ycWHVfumUm6Yy-QnuA.png" /></figure><p>Once you have added your Botsheets Key and Google Sheet link, the connection is activated.</p><h3>Manychat template</h3><p>You’ll get example flows that communicate with the Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtwOJy4EJ_yNdjVWA0RjIg.png" /></figure><p>When you install the template, open the flow Preview this flow to get started, click to edit the flow and preview the flow.</p><p><strong>Important: Make sure you preview the flow in Messenger.</strong></p><p>The flows are commented and if you’re familiar with the Manychat Flow Builder you’ll understand the logic, but you should refer to documentation on how to use the Manychat App in our documentation here:<br><a href="https://support.botsheets.com/docs/manychat"><strong>https://support.botsheets.com/docs/manychat</strong></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c681268cd128" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/starter-kit-messenger-c681268cd128">Starter Kit (Messenger)</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Starter Kit (Instagram)]]></title>
            <link>https://medium.com/botsheets/starter-kit-instagram-862c26dbcf87?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/862c26dbcf87</guid>
            <category><![CDATA[manychat]]></category>
            <category><![CDATA[instagram-dm]]></category>
            <category><![CDATA[instagram-chatbot]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 06 Apr 2024 09:03:42 GMT</pubDate>
            <atom:updated>2024-04-06T09:03:42.868Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SALb4PZqdeaU-mcpmbk-jQ.jpeg" /></figure><p>This toolkit includes:</p><ol><li>A Manychat template (along withBotsheets Action app)</li><li>A Google Sheet template that communicates with the Manychat template</li></ol><p>Once you have made a copy of the Google Sheet, Installed our Manychat template, and received and stored your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a>, follow this guide.</p><h3>Share Access To The Google Sheet</h3><p>Assuming you have made a copy of the Google Sheet template for this Toolkit, you’ll need make the Google Sheet shareable so that Botsheets can read your data. Click the green share button at the top right corner of Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/490/1*V8RtXJPwfjmKiD2MQlsm6A.png" /></figure><p>Change the share settings in Google Sheets so that <strong>Anyone on the Internet can view your sheet</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Svq28nG__WDaNBGmdXCGw.png" /></figure><p>Don’t worry as only those with the link can access the sheet data. Copy the link to your clipboard. You’ll give that read access to your Manychat bot.</p><h3>Set up the Manychat Action app</h3><p>When you install our Manychat template, it comes bundled with our Manychat Action app. This is where you’ll store your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a> and a link to your Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BCb2SnWZYVvn6REd.png" /></figure><p>You can access the Botsheets app through Manychat Settings &gt; Apps. Select the Botsheets app and add your Botsheets Key and shareable link to your Google Sheet</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*eMU7ycWHVfumUm6Yy-QnuA.png" /></figure><p>Once you have added your Botsheets Key and Google Sheet link, the connection is activated.</p><h3>Manychat template</h3><p>You’ll get example Instagram DM flows that communicate with the Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtwOJy4EJ_yNdjVWA0RjIg.png" /></figure><p>When you install the template, open the flow Preview this flow to get started, click to edit the flow and preview the flow.</p><p><strong>Important: Make sure you preview the flow in Messenger.</strong></p><p>The flows are commented and if you’re familiar with the Manychat Flow Builder you’ll understand the logic, but you should refer to documentation on how to use the Manychat App in our documentation here:<br><a href="https://support.botsheets.com/docs/manychat"><strong>https://support.botsheets.com/docs/manychat</strong></a></p><p>You’ll notice that we have two separate Actions, one for Messenger — You would see that if you installed a Messenger Toolkit, and one for Instagram DM.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aGjU-MvbdBoZt6ru5cZr1Q.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=862c26dbcf87" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/starter-kit-instagram-862c26dbcf87">Starter Kit (Instagram)</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Health & Beauty Toolkit (Messenger)]]></title>
            <link>https://medium.com/botsheets/health-beauty-toolkit-messenger-9768faaf0180?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/9768faaf0180</guid>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[manychat]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 06 Apr 2024 09:03:13 GMT</pubDate>
            <atom:updated>2024-04-06T09:03:12.905Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SALb4PZqdeaU-mcpmbk-jQ.jpeg" /></figure><p>This toolkit includes:</p><ol><li>A Manychat template (along withBotsheets Action app)</li><li>A Google Sheet template that communicates with the Manychat template</li></ol><p>Once you have made a copy of the Google Sheet, Installed our Manychat template, and received and stored your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a>, follow this guide to configure the connection.</p><h3>Share Access To The Google Sheet</h3><p>Assuming you have made a copy of the Google Sheet template for this Toolkit, you’ll need make the Google Sheet shareable so that Botsheets can read your data. Click the green share button at the top right corner of Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/490/1*V8RtXJPwfjmKiD2MQlsm6A.png" /></figure><p>Change the share settings in Google Sheets so that <strong>Anyone on the Internet can view your sheet</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Svq28nG__WDaNBGmdXCGw.png" /></figure><p>Don’t worry as only those with the link can access the sheet data. Copy the link to your clipboard. You’ll give that read access to your Manychat bot.</p><h3>Set up the Manychat Action app</h3><p>When you install our Manychat template, it comes bundled with our Manychat Action app. This is where you’ll store your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a> and a link to your Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BCb2SnWZYVvn6REd.png" /></figure><p>You can access the Botsheets app through Manychat Settings &gt; Apps. Select the Botsheets app and add your Botsheets Key and shareable link to your Google Sheet</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*eMU7ycWHVfumUm6Yy-QnuA.png" /></figure><p>Once you have added your Botsheets Key and Google Sheet link, the connection is activated.</p><h3>Manychat template</h3><p>You’ll get example Instagram DM flows that communicate with the Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtwOJy4EJ_yNdjVWA0RjIg.png" /></figure><p>When you install the template, open the flow Preview this flow to get started, click to edit the flow and preview the flow.</p><p><strong>Important: Make sure you preview the flow in Messenger.</strong></p><p>The flows are commented and if you’re familiar with the Manychat Flow Builder you’ll understand the logic, but you should refer to documentation on how to use the Manychat App in our documentation here:<br><a href="https://support.botsheets.com/docs/manychat"><strong>https://support.botsheets.com/docs/manychat</strong></a></p><p>You’ll notice that we have two separate Actions, one for Messenger — You would see that if you installed a Messenger Toolkit, and one for Instagram DM if you installed a Toolkit for Instagram</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aGjU-MvbdBoZt6ru5cZr1Q.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9768faaf0180" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/health-beauty-toolkit-messenger-9768faaf0180">Health &amp; Beauty Toolkit (Messenger)</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Automotive Toolkit (Messenger)]]></title>
            <link>https://medium.com/botsheets/automotive-toolkit-messenger-a7c5f2aa47e2?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/a7c5f2aa47e2</guid>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[manychat]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 06 Apr 2024 09:02:30 GMT</pubDate>
            <atom:updated>2024-04-06T09:02:30.569Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SALb4PZqdeaU-mcpmbk-jQ.jpeg" /></figure><p>This toolkit includes:</p><ol><li>A Manychat template (along withBotsheets Action app)</li><li>A Google Sheet template that communicates with the Manychat template</li></ol><p>Once you have made a copy of the Google Sheet, Installed our Manychat template, and received and stored your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a>, follow this guide to configure the connection.</p><h3>Share Access To The Google Sheet</h3><p>Assuming you have made a copy of the Google Sheet template for this Toolkit, you’ll need make the Google Sheet shareable so that Botsheets can read your data. Click the green share button at the top right corner of Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/490/1*V8RtXJPwfjmKiD2MQlsm6A.png" /></figure><p>Change the share settings in Google Sheets so that <strong>Anyone on the Internet can view your sheet</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Svq28nG__WDaNBGmdXCGw.png" /></figure><p>Don’t worry as only those with the link can access the sheet data. Copy the link to your clipboard. You’ll give that read access to your Manychat bot.</p><h3>Set up the Manychat Action app</h3><p>When you install our Manychat template, it comes bundled with our Manychat Action app. This is where you’ll store your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a> and a link to your Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BCb2SnWZYVvn6REd.png" /></figure><p>You can access the Botsheets app through Manychat Settings &gt; Apps. Select the Botsheets app and add your Botsheets Key and shareable link to your Google Sheet</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*eMU7ycWHVfumUm6Yy-QnuA.png" /></figure><p>Once you have added your Botsheets Key and Google Sheet link, the connection is activated.</p><h3>Manychat template</h3><p>You’ll get example Instagram DM flows that communicate with the Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtwOJy4EJ_yNdjVWA0RjIg.png" /></figure><p>When you install the template, open the flow Preview this flow to get started, click to edit the flow and preview the flow.</p><p><strong>Important: Make sure you preview the flow in Messenger.</strong></p><p>The flows are commented and if you’re familiar with the Manychat Flow Builder you’ll understand the logic, but you should refer to documentation on how to use the Manychat App in our documentation here:<br><a href="https://support.botsheets.com/docs/manychat"><strong>https://support.botsheets.com/docs/manychat</strong></a></p><p>You’ll notice that we have two separate Actions, one for Messenger — You would see that if you installed a Messenger Toolkit, and one for Instagram DM if you installed a Toolkit for Instagram</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aGjU-MvbdBoZt6ru5cZr1Q.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a7c5f2aa47e2" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/automotive-toolkit-messenger-a7c5f2aa47e2">Automotive Toolkit (Messenger)</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Real Estate Toolkit (Messenger)]]></title>
            <link>https://medium.com/botsheets/real-estate-toolkit-messenger-406a2f9c836c?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/406a2f9c836c</guid>
            <category><![CDATA[manychat]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 06 Apr 2024 09:02:15 GMT</pubDate>
            <atom:updated>2024-04-06T09:02:15.077Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SALb4PZqdeaU-mcpmbk-jQ.jpeg" /></figure><p>This toolkit includes:</p><ol><li>A Manychat template (along withBotsheets Action app)</li><li>A Google Sheet template that communicates with the Manychat template</li></ol><p>Once you have made a copy of the Google Sheet, Installed our Manychat template, and received and stored your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a>, follow this guide to configure the connection.</p><h3>Share Access To The Google Sheet</h3><p>Assuming you have made a copy of the Google Sheet template for this Toolkit, you’ll need make the Google Sheet shareable so that Botsheets can read your data. Click the green share button at the top right corner of Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/490/1*V8RtXJPwfjmKiD2MQlsm6A.png" /></figure><p>Change the share settings in Google Sheets so that <strong>Anyone on the Internet can view your sheet</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Svq28nG__WDaNBGmdXCGw.png" /></figure><p>Don’t worry as only those with the link can access the sheet data. Copy the link to your clipboard. You’ll give that read access to your Manychat bot.</p><h3>Set up the Manychat Action app</h3><p>When you install our Manychat template, it comes bundled with our Manychat Action app. This is where you’ll store your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a> and a link to your Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BCb2SnWZYVvn6REd.png" /></figure><p>You can access the Botsheets app through Manychat Settings &gt; Apps. Select the Botsheets app and add your Botsheets Key and shareable link to your Google Sheet</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*eMU7ycWHVfumUm6Yy-QnuA.png" /></figure><p>Once you have added your Botsheets Key and Google Sheet link, the connection is activated.</p><h3>Manychat template</h3><p>You’ll get example Instagram DM flows that communicate with the Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtwOJy4EJ_yNdjVWA0RjIg.png" /></figure><p>When you install the template, open the flow Preview this flow to get started, click to edit the flow and preview the flow.</p><p><strong>Important: Make sure you preview the flow in Messenger.</strong></p><p>The flows are commented and if you’re familiar with the Manychat Flow Builder you’ll understand the logic, but you should refer to documentation on how to use the Manychat App in our documentation here:<br><a href="https://support.botsheets.com/docs/manychat"><strong>https://support.botsheets.com/docs/manychat</strong></a></p><p>You’ll notice that we have two separate Actions, one for Messenger — You would see that if you installed a Messenger Toolkit, and one for Instagram DM if you installed a Toolkit for Instagram</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aGjU-MvbdBoZt6ru5cZr1Q.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=406a2f9c836c" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/real-estate-toolkit-messenger-406a2f9c836c">Real Estate Toolkit (Messenger)</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Recruiting Toolkit (Messenger)]]></title>
            <link>https://medium.com/botsheets/recruiting-toolkit-messenger-1943f45c4e34?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/1943f45c4e34</guid>
            <category><![CDATA[manychat]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 06 Apr 2024 09:01:48 GMT</pubDate>
            <atom:updated>2024-04-06T09:01:48.049Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SALb4PZqdeaU-mcpmbk-jQ.jpeg" /></figure><p>The Recruiting Toolkit is for staffing and recruiting agencies to help people find a job. Includes search examples for jobs by type, location, and other criteria.</p><ul><li>Show jobs: Generate galleries listing your current featured job opportunities.</li><li>Search jobs: Generate a gallery of jobs based on a keyword search.</li><li>Advanced job search: Generate a gallery of jobs based on specific search criteria.</li><li>Location search: Generate a gallery that ranks multiple locations by nearest distance to the user.</li></ul><p>This toolkit includes:</p><ol><li>A Manychat template (along withBotsheets Action app)</li><li>A Google Sheet template that communicates with the Manychat template</li></ol><p>Once you have made a copy of the Google Sheet, Installed our Manychat template, and received and stored your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a>, follow this guide to configure the connection.</p><h3>Share Access To The Google Sheet</h3><p>Assuming you have made a copy of the Google Sheet template for this Toolkit, you’ll need make the Google Sheet shareable so that Botsheets can read your data. Click the green share button at the top right corner of Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/490/1*V8RtXJPwfjmKiD2MQlsm6A.png" /></figure><p>Change the share settings in Google Sheets so that <strong>Anyone on the Internet can view your sheet</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Svq28nG__WDaNBGmdXCGw.png" /></figure><p>Don’t worry as only those with the link can access the sheet data. Copy the link to your clipboard. You’ll give that read access to your Manychat bot.</p><h3>Set up the Manychat Action app</h3><p>When you install our Manychat template, it comes bundled with our Manychat Action app. This is where you’ll store your <a href="https://m.me/botsheets?ref=w7955135">Botsheets Key</a> and a link to your Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BCb2SnWZYVvn6REd.png" /></figure><p>You can access the Botsheets app through Manychat Settings &gt; Apps. Select the Botsheets app and add your Botsheets Key and shareable link to your Google Sheet</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*eMU7ycWHVfumUm6Yy-QnuA.png" /></figure><p>Once you have added your Botsheets Key and Google Sheet link, the connection is activated.</p><h3>Manychat template</h3><p>You’ll get example Instagram DM flows that communicate with the Google Sheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtwOJy4EJ_yNdjVWA0RjIg.png" /></figure><p>When you install the template, open the flow Preview this flow to get started, click to edit the flow and preview the flow.</p><p><strong>Important: Make sure you preview the flow in Messenger.</strong></p><p>The flows are commented and if you’re familiar with the Manychat Flow Builder you’ll understand the logic, but you should refer to documentation on how to use the Manychat App in our documentation here:<br><a href="https://support.botsheets.com/docs/manychat"><strong>https://support.botsheets.com/docs/manychat</strong></a></p><p>You’ll notice that we have two separate Actions, one for Messenger — You would see that if you installed a Messenger Toolkit, and one for Instagram DM if you installed a Toolkit for Instagram</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aGjU-MvbdBoZt6ru5cZr1Q.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1943f45c4e34" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/recruiting-toolkit-messenger-1943f45c4e34">Recruiting Toolkit (Messenger)</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Botsheets vs. Manychat]]></title>
            <link>https://medium.com/botsheets/botsheets-vs-manychat-4268ad9d59b1?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/4268ad9d59b1</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[chatbots]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[manychat]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Sat, 02 Dec 2023 01:04:19 GMT</pubDate>
            <atom:updated>2023-12-02T01:04:19.830Z</atom:updated>
            <content:encoded><![CDATA[<h4>Two tools that help marketers automate conversational experiences, but what’s the difference?</h4><p>Manychat, an early mover in the chatbot space is considered to be the leader in “Chat Marketing”, providing a platform for marketers to automate conversations through social channels including Facebook Messenger, Instagram DM, and WhatsApp.</p><p>The platform servers mainly digital marketing agencies and small business. One of the main features of the chatbot platform they provide is what they call a “Flow Builder”. This is a no-code way to design a chatbot experience. Here is how it works. You add boxes onto a canvas and connect them together. Each box, technically referred to as a “Node”, serves a different function. One might be to display text, one might be to display an image, one might be to add or remove a tag for a user, and most importantly the canvas provides an easy way for marketers to visualize their conversational experiences as they build it without writing a single line of code.</p><p>While you can quickly see the value of the Manychat Flow Builder after just adding a few boxes, connecting them together, and then previewing a chat conversation, the big challenge is that most content is better served by a database rather than a static canvas where you might add a few boxes.<br>Let’s assume that you’re building a chatbot for a restaurant and you have a menu of food. If you use the Manychat Flow Builder to manage this content, it becomes an overwhelming mess to manage.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*K3agbB0dw-9ycctXZWPWlA.png" /></figure><p>This problem is further complicated by the fact that “Galleries” a box that would allow you to add multiple images and present a series of cards in a conversation only has a maximum of number of 10 slots. There are several use cases where you would have more than 10 slots and be limited</p><ul><li>Real Estate listings</li><li>Restaurant menus</li><li>Ecommerce products</li><li>Events</li><li>A directory of people</li></ul><p>These are some obvious use uses cases where you would want to retrieve data from a database and dynamically generate content. Marketers, the primary users of Manychat, don’t have the skills or resources to set up and manage a database, but since they already work with Google Sheets to manage marketing data, they could use Google Sheets as a database for managing chatbot content.</p><p>Botsheets makes it easy to do that. You simply add data into our Google Sheet templates, and you can add a box in the Manychat Flowbuilder that can include commands to search the Google Sheet and generate content for Messenger and Instagram DM.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I0Ngr4C6bmvJoWUHtmUHaQ.png" /></figure><p>As you can see in the example above, a real estate agent could easily manage listings from a spreadsheet, while their Manychat bot could search the Google Sheet and generate a gallery of cards in Messenger. The content is dynamically generated and can include specific parameters to search and render the content as well.</p><p>With the popularity in Botsheets for Manychat, we then added a number of other features that allow a Manychat bot to interact with Google Sheets, including the ability to generate selection lists, so you could for example present options for users to select, an interface not natively supported in a chatbot. Here is a complete overview of what you can do with Manychat and Botsheets:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FeqZKLR2f3RY%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DeqZKLR2f3RY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FeqZKLR2f3RY%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/26fc088faf069da7e4c4fa86842b5e25/href">https://medium.com/media/26fc088faf069da7e4c4fa86842b5e25/href</a></iframe><p>What’s ideal about using Google Sheets as a database for chatbot content, in addition to providing a lightweight database, it provides the ability to securely share and collaborate, so if you’re an agency, you can easily share access to a Google Sheet with a client and have them contribute content without the client ever needing to access the Manychat dashboard.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4268ad9d59b1" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/botsheets-vs-manychat-4268ad9d59b1">Botsheets vs. Manychat</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Botsheets vs. ChatGPT]]></title>
            <link>https://medium.com/botsheets/botsheets-vs-chatgpt-75898f5e7146?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/75898f5e7146</guid>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[gpt]]></category>
            <category><![CDATA[chatgpt]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[chatbots]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Fri, 01 Dec 2023 19:05:38 GMT</pubDate>
            <atom:updated>2023-12-01T19:05:38.070Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qj8t2tl3T0ZrcyPD1jR40Q.png" /></figure><h4>What’s the difference between the two?</h4><p>ChatGPT took the world by storm when it first launched in late 2022. What OpenAI got right was that it made conversational AI accessible to the mass market. The technology itself was a major breakthrough, using transformer technology to generate delightful responses, but the time at which you could get value from that technology was immediate. You simply send a message and a chatbot provides a delightful response.</p><p>In late 2023, the company announced another major game changer, “GPTs”, the ability to create your own custom GPT and with a plan to launch an App Store for these GPTs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J8-wVdT8hr2YUhZGX_JJ4w.jpeg" /></figure><p>The is a significant step forward because OpenAI is now democratizing the creation of AI agents. You don’t need to be an developer, or write a single line of code to be able to create custom AI apps. You can simply use prompts to train GPT to perform certain tasks and then make these GPTs accessible to everyone if you choose.</p><p>Third party companies too have created a number of pre-built “Actions”, what OpenAI refers to events in the GPT experience that allow GPTs to interact with external applications. In this example, Zapier a popular no-code solution to connect applications has a large library of pre-built actions that will enable a GPT to interact with a calendar.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CzFktdjwo6Ua6h6IB6eltQ.png" /></figure><p>It’s even possible to enable a GPT to write data to a calendar using Zapier actions, or add a row to a Google Sheet.</p><p>The main drawback for businesses that want to create their own GPT is that the conversational experience lives inside of ChatGPT and requires a ChatGPT Plus subscription which is a barrier to interacting with business.</p><p><a href="https://www.botsheets.com/">Botsheets</a> on the other hand provides a few key differentiators. The first of which is that the conversational experience lives on a website, because the goal is to help businesses freely collect valuable first party data from website visitors. The conversational experience can be full screen, embedded into a page, or a chat widget can be dropped into the bottom corner of any webpage.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gq1eq_gmeIKxiqfEXdPIoA.png" /></figure><p>Botsheets is in fact built with the ChatGPT 4 API so it’s the same AI that you would access inside of ChatGPT, but our developers have done a few significant modifications with it to make lead generation a viable use-case for a chatbot.</p><h4>Direct integration with Google Sheets</h4><p>This one should be obvious from the name “Botsheets”. We have a direct Google-approved integration with your Google Drive giving us full control over how we write data to a Google Sheet and without the need for third party apps like Zapier. This also eliminates the need to pay a third party if your goal is simply to get data into Google Sheets. If you want to move data into any other system such as a CRM, you could always export the data from Google Sheets, or sync the data with a third party system at that point.</p><h4>Autonomous data collection</h4><p>The goal for a Botsheets chatbot is to collect actionable lead data, but rather than having business manually set up questions and arrange those questions in a logical flow, Botsheets takes a fully autonomous approach. You simply tell AI what data you want to collect from an audience and AI will determine what questions to ask, how to ask them, and when to ask them, generating a logical flow in real time depending on how the user engages with a chatbot.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mQkhYN1ZAiy9ALZyFRrf9Q.png" /></figure><p>Botsheets will suggest data points based on your goal for a chatbot, and you can manually add your own custom data points. Once you’ve done that, the chatbot will work towards your goal and generate questions to collect the data. Just by providing indicating what data you want to collect, within minutes your chatbot is fully enabled for lead generation:</p><p>Your chatbot will decide what questions to ask, when to ask them, and how to best ask them to collect your data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/395/1*g2s7WqHVJJ8wpT-9LzNiAA.png" /></figure><p>Your chatbot will validate data input and rephrase questions if needed to collect acceptable input.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/396/0*nMe27tQrKv4zFvqn.png" /></figure><p>For data you indicate as required, your chatbot will be persistent about collecting it</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/397/0*7UV8nEVN14bvhQsA.png" /></figure><p>Set a goal for your chatbot and it will refocus users to ensure it’s working towards your goal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/395/0*E2gD5oOyLuEDTP5o.png" /></figure><p>Your chatbot will only respond to questions with data you import and if its related to your data collection goal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/396/0*sTMVQPnE7-Tx2rYC.png" /></figure><p>Your chatbot will engage with an audience in hundreds of different languages.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/398/0*TRRq-RX2uqxaw-Ko.png" /></figure><p>Set custom rules of engagement for your chatbot, including the tone your chatbot uses when engaging in conversation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/396/0*qAZIE8rrcyoN0rtS.png" /></figure><p>Your chatbot will deliver the data you want to Google Sheets where you can securely analyze, share, or sync your data with hundreds of business tools.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4L4wAyZM2ngPcFUg.png" /></figure><h3>Wrapping Up</h3><p>While GPTs are useful to create chatbots that serve your own needs, and if you chare a GPT, the needs of others, <a href="https://www.botsheets.com/">Botsheets</a> is very much a custom layer built on top of GPT that works out-of-the box to serve your lead generation goals directly through your own website. You can also train a Botsheets chatbot to answer questions trained on your business data, a standard feature of any custom GPT chatbot solution, but Botsheets will extract data from those messages, minimizing the amount of questions you need to ask. The entire lead generation experience feels natural and is a two way converation that uses AI to help you achieve your lead generation goals.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=75898f5e7146" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/botsheets-vs-chatgpt-75898f5e7146">Botsheets vs. ChatGPT</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Chatbase Alternatives in 2023]]></title>
            <link>https://medium.com/botsheets/5-chatbase-alternatives-in-2023-9ca9401ecda6?source=rss----3b1faf3efb66---4</link>
            <guid isPermaLink="false">https://medium.com/p/9ca9401ecda6</guid>
            <category><![CDATA[lead-generation]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[chatbots]]></category>
            <category><![CDATA[chatgpt]]></category>
            <category><![CDATA[gpt]]></category>
            <dc:creator><![CDATA[Josh Barkin]]></dc:creator>
            <pubDate>Thu, 30 Nov 2023 23:30:39 GMT</pubDate>
            <atom:updated>2023-12-01T15:29:47.040Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nqlUdCXL_EfwauOp4Wq1WQ.jpeg" /></figure><h3>Top 5 Chatbase Alternatives in 2023</h3><h4>Custom GPT chatbot solutions for your website to automate customer support and lead generation</h4><p>In the ever-evolving AI landscape, chatbots powered by ChatGPT have been a game-changer for streamlined lead generation and customer support. Sophisticated virtual assistants that understand and engage with users in natural language in any language are now only a few clicks away, enabling automated conversational experiences for end users while enhancing operational efficiency for business.</p><p>OpenAI not only made conversational AI more accessible to a mass market with ChatGPT, but by extending developer tools via their API, made it possible for startups to build viable businesses on top of ChatGPT. Before we committed resources to building <a href="https://www.botsheets.com/">Botsheets</a>, a ground-breaking use of the ChatGPT API for lead generation, we analyzed more than 100 “Custom GPT” business solutions and we’ll examine 5 of the more popular tools on the market alongside Botsheets and highlight key market differentiators.</p><h3>Chatbase</h3><p>Chatbase was one of the earliest market movers when OpenAI released its API for ChatGPT. With the mass market just recently discovering the magic of chatbots powered by OpenAI’s transformer technology to generate content, immediately businesses were keen to explore the possibilities of creating their own custom GPT chatbots for their website to serve their customers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UTB2qP9bxRtInKiKNoKjhQ.png" /></figure><p>Chatbase’s simple and intuitive user experience was easy to adopt. Its main use case was to help businesses create a conversational knowledge base to automate customer support. You could upload documents in a variety of formats and instantly get a responsive chat widget you could embed into your website. The early success of Chatbase and the developer’s quick path to market as an early adopter spawned a plethora of other Custom GPT “wrapper businesses” in a short time thereafter, yet all offering the same value proposition without any key differentiators. This quicky saturated the market with Custom GPT chatbot solutions for business.</p><p>Chatbase’s low entry price point was attractive for businesses, including a free tier to quickly experience value, but their higher tiers were priced much higher than market alternatives which made the landscape wide open for others to try and capture some market share.</p><p>Chatbase’s AI powered knowledge base for websites was well received, however Chatbase and the businesses they served missed the opportunity to capture valuable first party data from website visitors. In short, they overlooked the most potent opportunity for a chatbot…lead generation. When the market asked for the ability to capture lead data, the effort was mediocre at best, providing the option to capture a name, email address, and phone number.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rZpxM5bVzyQLWq-Kb6abOA.png" /></figure><p>The end user experience also resulted in shoehorning form fields into a chat session which felt awkward, unnatural, and giving end users little reason to provide input.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/883/1*EXLb5Fs-YWvrZxErT3vQGQ.png" /></figure><p>Chatbase is still a viable option for automating customer support on your website and creating a conversational knowledge base, but with it’s lack of lead generation capabilities, there are likely better alternatives on the market.</p><h3>1. Botsheets</h3><p><a href="https://www.botsheets.com/">Botsheets</a> was built on the premise that nearly every business already uses spreadsheets to manage data and the company doesn’t want to change that, but rather build an AI layer on top of software businesses already use.</p><p>While Google Sheets provides a structured data format that makes it easy to train AI on business data, the Google Sheets API provides an easy way to get data into Google Sheets. While businesses might be able to accomplish the same task using something like Zapier, this adds 3rd party costs on a per-request basis that can already be accomplished with Botsheets, making market alternatives overly expensive for businesses that want to collect data.</p><p>Moreover, Botsheets takes a unique approach to data collection by enabling chatbots that autonomously ask questions to collect data. While every other Custom GPT solution is using ChatGPT to generate responses and Botsheets does the same, Botsheets uses OpenAI to generate questions, letting AI determine what to ask, how to ask them, and when to ask them in order to meet your lead generation goals. It accomplishes this through a simple wizard where you simply provide a goal for your chatbot and Botsheets will suggest data points you will want to collect. You can also add your own custom data points.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EHsZiQv0Oa3uvjiMn5WaHg.png" /></figure><p>The simple “Wizard” approach to creating a chatbot is quite efficient providing other baseline features such as importing PDF documents and scraping a website to answer questions too, and if a Botsheets chatbot can extract data from user queries, then that only minimizes the number of questions your chatbot needs to ask. In short, a Botsheets conversational experience feels much more natural with a 2–way discovery experience between a customer and the business that wants to engage them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mTrSHHxcqLsLw_Azf-9AYw.png" /></figure><p>Of course, the Botsheets solution comes with all of the other standard features you’d expect, such as code to embed a customizable widget, and the ability to access transcripts so you can identify opportunities to improve your chatbot, but efficiencies are realized by accessing data your chatbot collects in Google Sheets where you can securely analyze, share, collaborate, export, and sync your data with hundreds of 3rd party CRM or other tools. If you work with spreadsheets and your goal is to automate data collection with a chatbot powered by ChatGPT, then Botsheets is a logical choice with a free plan and flexible pricing as you scale.</p><h3>2. Dante AI</h3><p>Similar to Chatbase, Dante AI was both an early mover in the custom GPT wrapper space offering chatbots trained on your business data with a goal of powering a conversational knowledge base for websites.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/634/1*1zOHldE3yJySkG46umk6OQ.png" /></figure><p>Pushing a no-code solution it claims powers more than 100,000 businesses, Dante AI’s claim is that it already provides direct integrations with popular messaging platforms including Messenger, Slack, and Discord. Creating a knowlege base is intuitive and with support for multiple file types including the ability to not just import documents and scrape websites, but also images and videos. However, similar to Chatbase, Dante has limited functionality to support a lead generation use case. The execution of it’s lead generation functionality is restricted to traditional forms embedded into a chat experience.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wNiWltmK-XweqbR3YQox2A.png" /></figure><p>Forms already have a high abandonment rate, with form styling matching Dante’s user experience having a 60% abandonment rate. It’s very likely that while a Dante AI conversational experience may be helpful for support automation, there is a good chance these conversational experiences have a low conversion when it comes to lead generation. Further if you want to get data out of Dante AI into a 3rd party system such as Google Sheets, you’re going to be paying additional fees on a per-request basis using Zapier. With an entry price point of just $10/month Dante will provide some value, but that should quickly add up with all of the extras you’ll want to really capture 1st party customer data on your website.</p><h3>3. Fini</h3><p>Fini is another advanced no-code AI chatbot platform that makes it easy to create a converational knowledge base for customer support. Like others mentioned here including Chatbase, Fini takes just a few minutes to set up by uploading and importing documents to train ChatGPT on your business.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*YlDkymTj2JGo-Cka" /></figure><p>Fini’s chatbots will mimics human-like conversation and lets you configure the tone your chatbot will use, and enables smooth human routing for problems better solved by humans. Fini also prvides easy integrations with Slack and Discord. Pricing includes a free plan with up to 50 questions/month and with plans scaling up to enterprise and providing unlimited queries with volume discounts. While Fini does make it easy to automate customer support, it lacks lead generation capabilities found in chatbot tools like Botsheets.</p><h3>4. CodyAI</h3><p>Cody AI offers a seamless no-code chatbot solution aimed at elevating customer service and boosting internal productivity. Another Chatbase alternative, Cody AI turns your existing knowledge documents into chatbots powered by ChatGPT</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*o6oK3aXxhjavlp6w" /></figure><p>Its straightforward setup eliminates the need for coding or technical expertise and unlike other ChatGPT wrapper businesses highlighted, it facilitates team collaboration. To note that it offers pre-configured use-cases and integrates effortlessly with third-party messaging platforms like Slack and Discord. Pricing is comparable to Botsheets at $29/month for a starter package and scaling up to $249/month. Also similar to Botsheets provides chat logs so you can track all interactions with Cody — whether through the Interface, API, or Widgets — in one unified place. For your convenience, you can filter these logs by bot or date range, simplifying your access to essential information.</p><h3>5. Chatsimple</h3><p>Like other CustomGPT solutions profiled here, Chatsimple is another ChatGPT wrapper to create a conversational knowledge base for your website. While Chatsimple includes integrations with Salesforce and Hubspot, ideal integrations for lead generation and sales, it’s end user experience for lead generation is similar to Dante AI and Chatbase where form fields are are “shoehorned” into a conversational experience and doesn’t provide an elegant solution for data collection the way Botsheets does.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9Vh2XtG1RyA307DMz0a2pQ.png" /></figure><p>Chatsimple’s capabilities though match the brand with easy document ingestion, quick set up time, multi-language support and customizable widgets for your website to match your brand’s look and feel. Pricing is on par with other Custom GPT solutions on the market starting at $29 and a “Free” plan which is essentially serves as a free trial of the software.</p><h3><strong>Wrapping Up</strong></h3><p>While all of these AI chatbot solutions are essentially wrappers on top of ChatGPT, which one is right for your business is up to you. Chatbase provides a simple entry level solution for automating customer support but falls short on lead generation. Others such as Dante AI, Chatsimple, and CodyAI offer mostly the same capabilities as Chatbase but similarly also fall short on the lead generation use-case. <a href="https://www.botsheets.com/">Botsheets</a>, while deeply focused on building on top of spreadsheets, provides all of the standard features you would expect to automate a knowledge base but puts lead generation up front as a core value proposition with unique capabilities to generate questions and capture leads in Google Sheets.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9ca9401ecda6" width="1" height="1" alt=""><hr><p><a href="https://medium.com/botsheets/5-chatbase-alternatives-in-2023-9ca9401ecda6">5 Chatbase Alternatives in 2023</a> was originally published in <a href="https://medium.com/botsheets">Botsheets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>