How to connect a new sheet and use filters

Status: Open · Asked by Hardi H on · 0 views

Hardi H — Question ·

Hello there!

Today I was trying to connect a new sheet in a workflow but it was not getting connected even though I connected my Google Drive account with Pabbly. Please guide me on how can I connect a new sheet for a new workflow. And from that sheet too, I want to use the data of a particular tab.

I've one more question. How do I set filters from the sheet in Pabbly and will Pabbly work if I set filters this way? Some columns have data and some don't.

Here I've give references for better understanding:

and column has inconsistency like this too

Your guidance will help a lot. Thanks in advance!

Himesh Soni — Reply ·

Hello @Hardi H , try using incognito mode if that works. To connect a new sheet you need to use app google sheet and select event as per your requirement. For filter use "is empty" Filter.
FYI I'm not from pabbly connect team I'm just freelancer who help other pabbly users.

Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
Hardi H — Reply ·

Hey Himesh,

I was using Google sheet as an app only but how to know which sheet is being used? For the context, ive used other sheet too for another workflow and I want to use another sheet for this workflow.

Let me know if you know the answer for that! :)

Also if you have any idea about filters and inconsistency:)

Arshil Ahmad — Reply ·

If you want to connect to a different sheet, you need to set up Google Sheets as your trigger step and establish a connection with that particular sheet by following the exact steps given below. Since both sheets are completely unrelated, you need to set up the trigger step again.

youtube.com/watch?v=3ZixI8a3XC4

Also if you have any idea about filters and inconsistency:)

Please make a short screen recording elaborating a bit more on this concern.

Hardi H — Reply ·

Hello Arshil,

As shown in the video, I signed in to my Google account but I was not able to find the sheet I wanted to integrate. Let me know what could be the issue or how to solve it.

For the filter part, I have attached the video for your reference. I want to run a WhatsApp campaign for those who fall into the distributors category. Let me know how to do that! My concern is, that not the whole column has drop-down buttons, and even where it has, not all of them are filled. Will filters or functionality still work? If yes, can you please tell me how?

Thanks in advance! :)

PS: I just realized that I'm not able to upload videos. So here I'm attaching SS again.

Himesh Soni — Reply ·

Hello @Hardi H , I guess you need to watch the videos of pabbly connect. https://youtube.com/@Pabbly si=IkbErsbNwoXK6oT5

This is their official YouTube channel you'll find your query related videos here.
In case you are unable to find the videos or you'll need any help you can DM me so that we can look into your iasue.

Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
Hardi H — Reply ·

Hello @Himesh!

Sure, let's wait for a response from the team and see if they can help me first!

I really appreciate your activeness and prompt reply! :)

Himesh Soni — Reply ·
Hello @Himesh!

Sure, let's wait for a response from the team and see if they can help me first!

I really appreciate your activeness and prompt reply! :)


Sure
Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
Arshil Ahmad — Reply ·
Hello Arshil,

As shown in the video, I signed in to my Google account but I was not able to find the sheet I wanted to integrate. Let me know what could be the issue or how to solve it.

For the filter part, I have attached the video for your reference. I want to run a WhatsApp campaign for those who fall into the distributors category. Let me know how to do that! My concern is, that not the whole column has drop-down buttons, and even where it has, not all of them are filled. Will filters or functionality still work? If yes, can you please tell me how?

Thanks in advance! :)

PS: I just realized that I'm not able to upload videos. So here I'm attaching SS again.


Please upload the video to Google Drive and share the link with us, so that we can better understand your issue.

Back to all forum threads · Log in to reply