Hi, this is my first post and I will appreciate some help 🙂
I need to access to a Google Sheets file, apply filters to 3 colums and then copy the resulted rows to a data table (SQL or Excel File).
Can someone tell me how to do this?
Thanks!
Hi @Ginottini
Try this as per the demo flow
Assume i have a google sheet like this
Also i have created a excel file template to store the final data
Now see the flow design
1. Use get rows action to get all rows present in a google spreadsheet. (you have to create a connection to your google account by signing in if using this action first time)
2. Use filter array to filter the records dynamic content with required filter , for the demo flow purpose i have used the following filters
Filter column A with value 1
Filter Column B with value FGH
Filter column c with value 567
use this approach to do it in filter array action
expression -
do same for B,C,D columns as well.
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Share
Report
All responses (
Answers (
18,138
