Making “Translation Please” (Part 2) – Integrations Block -> Intermediate
This part covers the use of the Integrations Block in the making of the skill.
The red box in the image is my Integrations Block, and what it looks like AFTER it has been set up. The green logo shows that it’s setup to use a Google Sheets. The next section shows the gmail address it is using. I only use a small portion of one sheet, so the third part shows “Sheet1”. The green checkmark icons show that all four of the sections have been set up. At the bottom is a “Test Integration” button that you can click to check your settings.
This is what a new Integrations Block’s edit panel looks like when you first see it.
It shows buttons for a couple of ‘future’ integration partners, Airtable and SendGrid. It also shows a button for custom APIs and the one we are using for this tutorial, Google Sheets.
the first thing to do (AFTER you have the demo sheet created) is click the google Sheets button.
The next image shows the edit panel,
AFTER you click the Google button.
Click the “Retrieve Data” button and choose “Update Data” from the drop-down list.
If you haven’t used the block before, you will have to enter a gmail user address and verify it.
If you have more than one, as I do, choose the one the sheet is registered to.
Choose the name of your spreadsheet from the drop-down list.
Then choose the sheet. You should only have 1 for this project.
Finally, you choose the ROW number. I put 2 in here because it was the demo I was working on at the time and it only had ONE ROW of data. In my final version, I used a variable that had a value betwen 2 and 11.
The last thing to add is the variable for the text (sentence, phrase or word) that you want translated.
You can test the integration by clicking the test button at the bottom of the panel.
That’s all there is to UPDATING a cell on a Google Sheet. When you get to the stage, everything is essentially the same, except when you click the “Retrieve Data” button, you select “RETRIEVE DATA” from the list.
That’s all folks!! The third tutorial is now available. It will ‘walk you through how the project gets the sentence to be translated. Hope you liked this one.