AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Google sheets help chat1/30/2024 This newest feature allows you to update the information in a Google Sheet you had already filled before, using a column and a Custom Field as the lookup values.ġ. And if you have two or more the same values, then the user will receive the first one. Note: if Google Sheet doesn’t find any value identical to Lookup Value, then it wouldn’t return anything. That will make sure that the same user won't be available to get the code twice. If he has, he will receive the message that he already received the coupon. Note that the second Condition checks if the user has a "Coupon_received" tag which is applied only when the user do not have it yet. If Lookup Value is more than the number of the coupons and there are no more coupons, nothing will be mapped to the "user_coupon_id" Custom Field and we'll sent the second message "No coupon". If there is a coupon, we'll increase "coupon_id" by 1 - that will increase Lookup Value and move us through the list giving the next contact the next coupon. We're receiving the coupon ID and checking with Condition if the user received the coupon at all ( we need it in the case there are no more coupons). We are making the request to Google Sheet ( described on the screenshot above). We're going to make a Flow that will give contact a coupon after the click on the button. It will find a Row with "1111-11111111-111111-1111" code and map it to the chosen Custom Field. And then Man圜hat goes and looks for "3" in the Google Sheet Column "ID"- this is Lookup Column. Refer to the screenshot below to match the narrative with the live action through the guide!ģ. Text Custom Field "coupon_code" in Man圜hat,Īnd it basically works like this: Man圜hat takes value from the Number Bot Field "coupon_id", looks for the number in the sheet and saves it in the specified Custom Field, "user_coupon_id" in our case.įor example, value of "coupon_id" is now 3 - this will be Lookup Value. Our integration allows you to import data from the Google Sheet into Custom Fields in Man圜hat. Get a row from Google Sheet by lookup value Note: If you want to change the structure of your Worksheet, you have to go to the wizard of your Google Sheets Action and refresh the fields. Now you can try your flow, and then chosen data will appear in your Worksheet. All contact's data, Custom User Fields, Bot Fields or Tags are available to send. Choose your spreadsheet, worksheet, and match Man圜hat fields to the worksheet fields. Click on the Insert Row link, and Google Sheets wizard will appear.Ģ. Make a new action node and choose Google Sheet Actionsġ. Go to the flow where you want to add an actionģ. Create a new worksheet in your Google Docs and prepare column names on the first row of the documentĢ. You can add the integration action in one of your flows, and when your contact passes through this flow, their data will be pushed to your Google Sheet.ġ. Tap the button bellow: Connect Google Sheets Account, and confirm the authorization.ģ. Connect your Google accountįirstly, you have to connect your Google account to Man圜hat:Ģ. By integrating Google Sheets with ChatGPT, you can perform complex tasks without leaving the chat interface.From this article, you will learn how to connect your Man圜hat Account to Google Sheets, and how to simply transfer your contact's data to tables by actions in flows. Remember, the Access Google Sheets plugin is a powerful tool that can enhance your productivity and streamline your data management tasks. You can then use this data for further analysis or discussion.Ĭontinued Interaction: You can continue to interact with the Google Sheet through the plugin, requesting additional data or making changes as needed.
0 Comments
Read More
Leave a Reply. |