Best answer

Altering the structure of a google spreadsheet

  • 13 November 2020
  • 1 reply
  • 111 views

Hi,

I have a zap triggered by the adding of a new line in a google spreadsheet.

It exploits many of the columns (fields) from the document.

But now, I need to add a column right in the middle of the document.

Will it screw the mapping up, or is the mapping really connected to the name of the column ?

Thank you !

Michel Wozniak

icon

Best answer by Troy Tessalone 13 November 2020, 20:55

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Will it screw the mapping up, or is the mapping really connected to the name of the column ?

The mapping will be messed up, so you will have to remap the Zap.

 

Article: https://zapier.com/help/doc/common-problems-google-sheets-zapier#my-google-sheets-trigger-zap-stopped-working

In addition to this, the following changes to your spreadsheet whilst your Zap is turned on can cause a disconnect with your Zap:

  • Deleting existing rows or columns.
  • Adding rows anywhere other than to the bottom of your sheet.
  • Resorting the sheet.
  • Renaming/adding/rearranging new columns.
  • Renaming the sheet.