Is there anyway to get all columns data from google sheets to pabbly? I used the webhook plugin on google sheets to transfer the data but it does not

[trialanderror22]

Is there any way to get all column data from google sheets to pebbly? one by one ... I used the webhook plugin on google sheets to transfer the data, but it does not share all the entries in each column cell. Lastly ,if I try using search spreadsheet option it only display each cell as a separate way without providing me a way to attach each column one by one.

 

[Pabblymember11]

Hey @trialanderror22

Do you want to pass all the rows from your Google Sheets to the workflow at once, which will process the rows one by one?

 

[trialanderror22]

Yes please, when using send all data using the extension from google sheet;when using google sheet as an updated row or new row it only update and transfer the last index not all data.

 

[Pabblymember11]

Hey @trialanderror22

Yes please, when using send all data using the extension from google sheet;when using google sheet as an updated row or new row it only update and transfer the last index not all data.

Then you can use the "Send Custom Data" option to send the data from a range.

E.g. -

 

[trialanderror22]

It ended up working thank you