Filtered data from clickup form to Google sheets

[Pluviophile]

I have a petty cash application in clickup and integrated with google sheets. I want to display details of custom columns (request amount, invoice amount) of users and only users where status is fund transferred. can i do so and also can i add data in the way like details of user should group together so calculation should easy.

 

[Arshita]

Hello @Pluviophile

You can use the ClickUp application and Google Sheets integration in Pabbly Connect to extract the data from your ClickUp task and push it to the respective columns in your Google Sheet.

In order to display the details of custom columns for specific users, you can use the "Filter" option in your action step available in Pabbly Connect. By setting up filters, you can extract data only for users where the status is fund transferred.

To better understand how the filter step works in Pabbly Connect, please refer to the video tutorials below.