Pasting updated excel file into ChatGPT

Question

HI Team

I have excel table that gets updated by zappier when new task added to the asana,

Can anyone tell me how can I make zappier to paste entire excel table to chat GBT? Rather then specific row? I cant seem to find such option. I would appreciate any help.

A quick info about my automation:

I am trying to create an automation which would evenly distribute tasks across Asana project across 3 people, Therefore I have created a zippier automation that would take a newly assigned task to the project. Second step would be extract name of the person it assigned to. For third step I have created excel file, which contains a total number of task assigned to people within the project. So in third step I have Zappier add +1 to the person the task was assigned to. For example if task is assigned to Devin, zappier would add +1 to the number of task assigned to Devin.

What I am straggling now is to tell zappier to find the lowest number based on the updated table or pick a random one if we have two lowest number. Originally I thought to past such task into Chat GBT. However I cannot find a way to make zappier to pate a while table into Chat GBT.

My last step would be reassign Asana task to the person that have the lowest amount of task ( I have already figured out how to do this part )

I would appreciate any help or suggestions. Thank you

icon

Best answer by SamB 5 June 2023, 13:26

View original

SamB · Accepted Answer

Hey there,@Vovash! 👋It looks like the Microsoft Excel app has a Find Row action which would only be able to pull a single row at a time. You might be able to use a Looping by Zapier action (see: Loop your Zap actions) to get it to search for more than one row by giving it a list of other ones to search for, such as eachname. But you’d need to have a list of those supplied to the Looping by Zapier action from a previous trigger or action, or manually defined. That would then output the different information for each row of the table that was found into line items. Depending on how well ChatGPT can handle those line items,you might need to convert theminto text so that it can read the values for the entire table-Convert line items into text stringsThat said, it seems like what you could insteadis to set up a “round robin” in the Zap, to get the tasks evenly distributed to each person. We have a few guides on how to set up round robins that you might find useful:Example Use - Round RobinHope that helps to get you pointed in the right direction. Please do let us know how you get on with this!🙂

Vovash · Answer

HI Sam B @SamBThank for your help. I used loop the zap option.Although Round robin were looking as a great option,I am currently exploring round robin option further, as it a bit harder for me to understand. I just have a question. Assuming that 5 task in a raw will be assigned to Devin, which would result Devin havingfar more tasks then anyone else. Is there any chance to set up round robin in the way that it would not assigned any further task for Devin, as she already have the highest number of task and would assign it to the person with thelowest amount of task.Once again thank you for all the help!

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded