Replacing Google Sheets legacy Modules with New Modules

This documentation is specific to the Google Sheets app. For universal instructions for replacing legacy modules with new modules visit Replacing Legacy Modules with New Modules.

A majority of Integromat apps rely on external services, particularly on their APIs (Application Programming Interfaces). As the services evolve, so do their APIs. New API versions are being regularly released and legacy versions are getting deprecated and eventually shut down.

We closely follow releases of new API versions and implement new app versions based on the latest APIs.

To keep your scenarios running even after the shutdown of a legacy API, make sure to replace all the legacy (old) modules with new modules. 
Here is a step by step guide:

Step 1: Choose one of your legacy scenarios that is using legacy modules, and clone it as a new scenario.

  1. Go to the scenario diagram.
  2. Open the Options drop-down menu in the top-right corner and select the Clone option.
    5svZbPmH4G.gif
  3. Change the name to distinguish between the legacy scenario and the new scenario and click the Clone button.
  4. The new scenario (still with the legacy modules) is created.

Step 2: Have the legacy scenario and the new scenario open in two web browser tabs/windows to easily switch between them.

This step will make your copy-paste job faster and easier.

  1. Open Scenarios in a new browser tab.
  2. Open your legacy scenario.
    7TQLBf4hAI.gif
For Google Sheets: adding new Google Sheets modules to the scenario (Step 3, Step 4, Step 5) can be easily performed using Integromat DevTool.

Step 3:  In the new scenario, choose the legacy module and click on the "upgrade" arrows.

2020-01-15_13_18_01-Window.png

Step 4: Choose the corresponding new module from the list of modules.

The new module is placed in the scenario (not connected).

kJdPBvUm91.gif

For Google Sheets, check this table to find a new counterpart of your legacy module:

Legacy Module New Module
Add a Row Add a Row
Update a Row Update a Row
Delete a Row Delete a Row
Select Rows Search Rows
Update a Cell Update a Cell
Add a Worksheet Add a Sheet
Get a Cell Get a Cell
Watch a Worksheet Watch Rows
List Worksheets List Sheets
Delete a Worksheet Delete a Sheet

Step 5: Drag and drop the new module and connect it after the legacy module.

ycbGE2Zof3.gif

For triggers:

  1. Set the new module values in the same way as the legacy module values.
  2. Replace the legacy module with the new module.
    Jr5PxTMNnU.gif

Step 6: Copy and paste the module's values from the legacy module to the new one.

  1. Open the configuration of the new module.
  2. Switch to the tab with the legacy scenario and open the configuration of the legacy module.
  3. Copy and paste the content of each field from the legacy module to the new module by switching between the legacy scenario and the new scenario. If any items are missing in the mapping panel, please refer to our online documentation.
    YQoAcoMse4.gif

Repeat for every legacy module in the new scenario.

Step 7: Replace items that are mapped from the legacy module

  1. In the new scenario, choose a module that uses the output from a legacy module and open its configuration.
  2. For the fields of the proceeding module, replace the legacy items outputted from the legacy module with corresponding new items outputted from the corresponding new module.
    1GJtQkl8l6.gif

Repeat for every module that uses the output from the legacy module.

Step 8: Replace items that are mapped from legacy modules in filters

  1. In the new scenario, choose a filter that uses the output from a legacy module and open its configuration.
  2. For the conditions of the proceeding filter, replace the legacy items outputted from the legacy module with the corresponding new items outputted from the corresponding new module.

Repeat for every filter that uses the output from a legacy module.

Remove all the legacy modules from your scenario.

Repeat for every scenario using legacy modules.

Adding New Google Sheets Modules to a Google Sheets Scenario with the Integromat DevTool

  1. Add the Integromat DevTool extension to your Chrome browser.
  2. Open your Google Sheets (legacy) scenario.
  3. Press Control+Shift+I (Windows) or  Command+Option+I (Mac) on your keyboard to open Chrome Developer Tools.
  4. Go to the Integromat tab.
  5. Open Tools.
  6. Click on the Migrate GS tile.
  7. Click the Run button.

2020-01-15_16_36_01-Window.png

New Google Sheets modules are placed in your scenario. Proceed to enter the values from the legacy modules to the new modules as described in steps above.

Popular use cases from our blog

automated-data-collection-crm-illustration

How to Automate Data Collection - Part 5: CRM Systems

automated-data-collection-chatbot-marketing-illustration

How to Automate Data Collection - Part 4: Chatbot Marketing

automated-data-collection-paid-ads-illustration

How to Automate Data Collection - Part 3: Paid Ads

automated-data-collection-email-illustration

How to Automate Data Collection - Part 2: Email Marketing Segmentation

personalized-customer-experience-illustration-integromat

5 Automated Solutions to Personalize Customer Experience

data-collection-automation-forms-pt-1

How to Automate Data Collection - Part 1: Online Forms

Didn’t find what you were looking for?

Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.