Google Sheets Add Row Column Limit

[mjm]

Is there a limit on how many columns we can write data to while adding a new row in Google Sheets?

I am trying to add data to a sheet with 111 Columns but only 52 Column headers are visible in Pabbly Connect.

 

[Fagun Shah]

Yes, Add new row action has limit of 52 columns.

Use "Append Row" action instead.

 

[mjm]

Yes, Add new row action has limit of 52 columns.

Use "Append Row" action instead.

Append Row or Append Values?

 

[mjm]

Thank you for your help @Fagun Shah

Append Values will work.

Any way we can overcome this 52 columns restriction while updating an existing row?

 

[mjm]

@Supreme @Neeraj Please help.

 

[PabblyMember3]

Thank you for your help @Fagun Shah

Append Values will work.

Any way we can overcome this 52 columns restriction while updating an existing row?

For now, 52 columns will be supported, If we extend this in future, you will be notified.

 

[mjm]

For now, 52 columns will be supported, If we extend this in future, you will be notified.

Thank you for the confirmation. Will use Integrately for the time being.