How to setupĭrag and drop action Update Google Sheet block in the bot flow. When your chat user passes through this flow, their data will be pushed to your Google Sheet file and displayed in a new row. This action sends data collected by BotStar to your spreadsheet. You can now easily send data out to Google Sheet or retieve data from Google Sheet file to your chatbot. Query: search, access, retrieve data and bring it in (from Google Sheets) to your bot.ĭrag and drop action Update/ Query Google Sheet in the bot flow based on your use case. Update: send data out to Google Sheets, or edit data in the spreadsheets within your Google account. Jump to our visual builder after you complete the integration step, you can choose what actions to perform every time a reachable user interacts with a bot. Make sure to connect to the correct Google account that will use the spreadsheet. You will be asked to integrate your google account. Head to Bot Builder > Integrations and scroll down a bit to find Google Sheet Integration section > toggle it on and click Connect. If you want to change the structure of your spreadsheet/worksheet in the middle of the setting process, you must go to your Google Sheets Action and reload the chosen Spreadsheet and Worksheet fields.Īfter creating/checking your worksheet, let's go back to the flow and connect your Google account to BotStar to use the Google Sheets Integration. Note: The spreadsheet should be created in its final version before you enable integration. Head to your Google Sheet account, create a worksheet with column names on the first row of the document. To use this feature, you must have a spreadsheet in your Google Sheet account first. #Connect BotStar to your Google Sheet account #1. Take a look at this document to learn how to connect your BotStar Account to Google Sheets, and transfer your user’s data back and forth without a single line of code. To be specific, this feature allows you to search, access and edit data in the spreadsheets within your Google account automatically. This simple trick guide you can create a Google account using a non-Gmail email ID and then use Google Docs, Google Slides, and sheets to create, edit, and share the document files.It got much easier - now you can connect your existing Google Sheet account to BotStar without using any third-party apps. Now you can open Google Docs to access, create, edit or share the document with a non-Gmail Google Account.That’s it, you will be taken to your newly created Google Account without Gmail.In my case, it will be available in the ProtonMail inbox. Now a code will be sent to your email inbox.Enter the details, add the non-Gmail Email address, enter the password and click next.Now go to the SignUp Without Gmail Page.Create an Email Account using any free email provider other than Google.I will be using a Free ProtonMail Email service provider to Create a Google Account and use Google Docs, Google Sheets, and Google Slides. Here are Simple Steps to Access and Edit Google Docs without Gmail Account. Steps to Use Google Docs without Gmail Account Let me make it clear that when I say you can use Google Docs without a Gmail account it doesn’t mean you can use it without a Google account but it simply means you can use an alternative non-Gmail email ID etc) or a custom email ID (work/business email) to register a Google account and then use Google Docs.
0 Comments
Leave a Reply. |