Google Sheets Trigger

Customization Options

Configurable fields you can adjust in your automation

• Rules
• Filters for conditional step execution
• URL of your sheet document
• Exclude first row
• Do not process cell formulas
• Start from the last row
• Sheet selection mode
• Sheet Number (if selected by position)
• Sheet name (if selected by name)
• Column letter to filter by
• Row filters configuration
• Restart rules

Troubleshooting

Error messages and suggestions to fix it.

• addHow to loop through the rows of an empty column?
  The last row of a spreadsheet always depends on the column you select.
  
  If the selected column is completely empty then the spreadsheet will not contain any rows, even if there are values ​​in other columns.
  
  To loop through all the rows in an empty column, always add a value to the end of the column. In this way, the spreadsheet will be considered to contain rows.
  
  

---

Information provided

When executed, this operation delivers the following data, which can be used in the same automatic task.

• Tags

• Column A {{column_a}}

• Column B {{column_b}}

• Column C {{column_c}}

• Column D {{column_d}}

• Column E {{column_e}}

• Column F {{column_f}}

• Column G {{column_g}}

• Column H {{column_h}}

• Column I {{column_i}}

• Column J {{column_j}}

• Column K {{column_k}}

• Column L {{column_l}}

• Column M {{column_m}}

• Column N {{column_n}}

• Column O {{column_o}}

• Column P {{column_p}}

• Column Q {{column_q}}

• Column R {{column_r}}

• Column S {{column_s}}

• Column T {{column_t}}

• Column U {{column_u}}

• Column V {{column_v}}

• Column W {{column_w}}

• Column X {{column_x}}

• Column Y {{column_y}}

• Column Z {{column_z}}

• Number of Row (DEPRECATED) {{row_number}}

• Number of Row {{row}}

• Sheet name {{sheet}}

Common Errors