remove member when member joint channel 7 days

[manerayugi]

I see this video

I have a question

in Column C I fill Expiry Date of member

name	ID	Expiry Date
a	1	2024-10-07
s	2	2024-10-15
d	3	2024-10-30
f	4	2025-01-01

how to use Pabbly to solve it?

 

[Preeti Paryani]

Hello @manerayugi

Can you please whether you want to remove a user from the Telegram Group as per the Expiry date on Google Sheets?

 

[manerayugi]

Hello @manerayugi

Can you please whether you want to remove a user from the Telegram Group as per the Expiry date on Google Sheets?

yes.
Ex. id 1 kick from telegram channel in 2024-10-07

 

[Deleted member 15445]

Hey @manerayugi

Your use case seems possible. We have a video on our YouTube Channel where it is demonstrated how you can search a date from Google Sheets and put a Delay until that day to execute the further step. Kindly refer to this video below

For the last step, you can use telegram "Kick a Chat Member".

Let us know if it works for you.

 

[manerayugi]

Hey @manerayugi

Your use case seems possible. We have a video on our YouTube Channel where it is demonstrated how you can search a date from Google Sheets and put a Delay until that day to execute the further step. Kindly refer to this video below

For the last step, you can use telegram "Kick a Chat Member".

Let us know if it works for you.

It's not work. if data > 1 row

program will kick only first row

 

[ArshilAhmad]

You would need to set up two separate workflows to achieve this use case. Please try setting up your workflow in this exact manner and see if this gives you the desired result.

Pabbly

connect.pabbly.com

Pabbly

connect.pabbly.com

 

[manerayugi]

You would need to set up two separate workflows to achieve this use case. Please try setting up your workflow in this exact manner and see if this gives you the desired result.

Pabbly

connect.pabbly.com

Pabbly

connect.pabbly.com

It's not work
in Part 1 Error at this step

Can you create video how to setup step-by-step for help me?

 

[Preeti Paryani]

Hello @manerayugi

The warning you are facing is because the choose array field in the iterator step is empty.

Please capture the response from the "Google Sheets: Lookup Spreadsheet Rows V1" step in advance format and map the array response in the iterator step. Please refer to the attached screenshot for more info.

If you still face issues while setting up the workflow please let us know.

 

[manerayugi]

Hello @manerayugi

The warning you are facing is because the choose array field in the iterator step is empty.

Please capture the response from the "Google Sheets: Lookup Spreadsheet Rows V1" step in advance format and map the array response in the iterator step. Please refer to the attached screenshot for more info.

View attachment 48007

View attachment 48009

If you still face issues while setting up the workflow please let us know.

It's Work!. But work only first row. I'll try setting it to auto and see how it goes. If you have another way to kick more than one person out of a group at once, please let me know.

 

[Preeti Paryani]

Hello @manerayugi

Ok sure, please try this at your end and if we have any further workarounds we will let you know.

 

[manerayugi]

Hello @manerayugi

Ok sure, please try this at your end and if we have any further workarounds we will let you know.

It's Work!!! Thank you.

 

[Preeti Paryani]

Hello @manerayugi

Thanks for the update, we'd love to hear your thoughts! If you have a moment, please rate us on Google. Your feedback helps us improve.