Output to Google Sheets

I have a working integration with a Google Sheet but it only seems to allow me to send data to 52 cells in a row but I have a total of 61 cells needing the data filled in. What am I doing wrong or is this a limit? If it's a limit, what can I do to get the remaining 9 cells of data also filled in?

It is a limit.

Use Append Row action when there are more then 52 columns.

There is no option called "Append Row"

My mistake, it is called "Append Values",

Your suggestion does exactly what I thought it would do and it appends a NEW ROW with the data in this new row instead of in the row the 52 fields were just put in. This won't work since now the data is split between 2 rows.

You do not need to use "Add New Row" action anymore.

Did yu mapped all the 61 cells value in "Append Values" action and it created 2 rows Or you just mapped extra cells after 52 cells in "Append Values" action

OK. That makes sense. I now have a different issue. I need a formula in some of the cells in the row and with the 'add new row' or 'append values' option, I can't figure out how to add the formula I need so it can stay relative to the row without the quotation marks causing an issue for Pabbly since the text of the formula needs to be within quotations itself. Here's the formula I'm trying to use =SUMPRODUCT(LEN(INDIRECT("RC[-54]",false):INDIRECT("RC[-7]",FALSE))>0) which I've added as a value like this ,"=SUMPRODUCT(LEN(INDIRECT("RC[-54]",false):INDIRECT("RC[-7]",FALSE))>0)" but this gives an error. Any suggestions?

@Supreme @Pabbly please check this.

Thanks for your help but check what exactly?

They are from official pabbly team so related to having double quotes in formulas in Append Values action, they will answer you.

If you are available for zoom call we can try that. Below is my FB profile URL. Feel free to dm me and we can do some experiments on zoom call until Pabbly Team reply.

Maybe I don't know how to use this discussion board, but I thought the Pabbly team checked it regularly and they would eventually respond.

Maybe I don't know how to use this discussion board, but I thought the Pabbly team checked it regularly and they would eventually respond.

I think I found a solution

Better to create a new thread for this, and share screen-recording if possible. That would be more helpful.

I'll wait for @Supreme or someone else at Pabbly to reply since I couldn't solve this. The formula I need to send from Pabbly to Google sheets is this: =SUBSTITUTE(INDIRECT("RC[-6]",false),"61cf44ab613d49f353d7bfaa","Cab-over")

The issue seems to be with the "," in the formula affecting the Append Row function to the Google Sheet since "," is also the separator between data fields. I hope someone can offer a solution.

Try using single quotes in place of double quotes.

Doesn’t work

As you are using INDIRECT which is not supported by Spreadsheet Formatter, please check this list:https://www.pabbly.com/spreadsheet-formulas/

As you are using INDIRECT which is not supported by Spreadsheet Formatter, please check this list:https://www.pabbly.com/spreadsheet-formulas/

In that case, double quotes will not work in the append values action.