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.
#Google sheets login code#
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:Ģ.
#Google sheets login how to#
Customize the permission level to Viewer and uncheck the option to notify if preferred, then click Share or Send.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. Click the Share button in the top right corner.Įnter the Service account email address which you recorded previously (e.g., in Notepad), or it may be automatically suggested if you've already used it. Open a spreadsheet that you want to connect to from Dundas BI.
If you used a Gmail account to create your spreadsheets, first sign into Google Sheets. There are a couple of ways to proceed depending on the type of account used to create the spreadsheets. Now that the credentials have been generated, they must also be authorized to access the spreadsheet data.
Copy and paste this with the service account's e-mail address for later use.
#Google sheets login password#
If you require the P12 file type instead of the default JSON, you will require some additional information.Ī popup will appear displaying the password for the private key. This file will be needed later to set up a data connector in Dundas BI. When finished, a certificate file should be downloaded. For example, click to edit the new service account, go to the Keys tab if applicable, and click Add Key.
0 kommentar(er)
