Tutorial: Updating a table Integromat English English (auto-generated)

Tutorial: Updating a tableYouTube↗ IA↗(long shot)
Science & Technology 1.8K views 5 likes 0 dislikes 12 Sep 2016

Make 47.5K subscribers Czechia YouTube↗

Click to Play Video

Hello, in this video we will show you how you

hello in this video we will show you how you

can use the Select rows module from the Google sheets package to create a

can use the Select Rose module from the Google sheets package to create a

scenario that will automatically update exchange rates in a Google spreadsheet.

scenario that will automatically update exchange rates in a Google spreadsheet

The first thing we have to do is to prepare the table we want to update.

the first thing we have to do is to prepare the table we want to update the

The first row of the table should start with the headers that describe the columns.

first row of the table should start with the headers that describe the columns we

We will use the first two columns to enter the currency pair as we are interested in. Integromat will import current exchange rate for each pair into the

will use the first two columns to enter the currency pair as we are interested in Integra Matt will import current exchange rate for each pair into the

third column. The update date will be entered into the fourth column.

third column the update date will be entered into the fourth column now we

Now, we can create the scenario.The first module we are going to choose is the

can create the scenario the first module we are going to choose is the select

Select rows module from the Google Sheets package. We will select our currency file and set the maximum number of returned results.

rows module from the Google sheets package we'll select our currencies file and set the maximum number of returned results

Next, we'll add the Currency module. This module allows to convert an amount from

next we lied the currency module this module allows to convert an amount from

one currency to another using the most recent European Central Bank exchange rate.

one currency to another using the most recent European Central Bank exchange rate we'll set the amount to be

We'll set the amount to be converted to one end map, to see one

converted to one end map to see one

column into the input currency field and see two columns into the output currency field.

column into the input currency field and see two column into the output currency field the last module in our scenario

The last module in our scenario will be the Update row module from the

will be the update row module from the

Google sheets package.

Google sheets package

The row ID available from the first module determines which row shall be updated.

the row ID available from the first module determines which row shall be updated finally we will map the

Finally, we will map the information that we want to pull into

information that we want to pull into

our table, the exchange rate and the date of update.

our table the exchange rate and the date of update

The scenario is now ready and we can test it. As you can see, our table has been updated with the latest exchange rates.

the scenario is now ready and we can test it as you can see our table has been updated with the latest exchange rates

If you are still not sure how to set up your scenario or have any questions

if you are still not sure how to set up your scenario or have any questions

please contact us. We will be happy to help you.

please contact us we will be happy to help you thank you for watching our

Thank you for watching our tutorials and your interest in Integromat.

tutorials and your interest in Integra net you

Similar videos:

What is Integromat?
Make
111.8K views 88 likes 1 dislikes 11 Aug 201667% match

Tutorial: Connect any OAuth2 service to Integromat
Make
2.5K views 12 likes 2 dislikes 19 Jun 201763% match

Tutorial: Create Contracts for HubSpot CRM Contacts
Make
1.3K views 3 likes 1 dislikes 02 Jul 201857% match

Tutorial: Iterators & Aggregators
Make
1.7K views 4 likes 0 dislikes 23 Oct 201756% match

Tutorial: Working with Error Handlers
Make
2.2K views 7 likes 0 dislikes 25 Aug 201633% match

Tutorial: Working with JSON
Make
12.6K views 63 likes 8 dislikes 22 Sep 201629% match

Tutorial: Responsive Webhooks
Make
13.1K views 55 likes 5 dislikes 14 Feb 201725% match

Tutorial: Saving Photos and Videos from Google Drive to Dropbox
Make
738 views 6 likes 0 dislikes 14 Nov 201725% match

Tutorial: Routers and Filters
Make
3.4K views 4 likes 0 dislikes 01 Aug 201624% match

Tutorial: Working with Google Sheets
Make
3.7K views 6 likes 2 dislikes 22 Jul 201621% match

Tutorial: Emails to Google Sheets
Make
6.3K views 19 likes 3 dislikes 20 Nov 201721% match

Settings Privacy About Contact Donate