Hello! I’m not sure if I’m expecting too much from Zapier but I’m keen to roll this out for my firm’s pitch proposal process, if it can do what I want it to. We hold all of our experience of previous works in Google Sheets, all categorised by industry and work type. Can Zapier:
- When a new tender is put into Monday, the trigger to be when a new entry is made into column “industry type” eg mining
- Zapier to search the relevant Google Sheets worksheet, and find experience relating to anything that has been categorised as “mining” from a cell
- The information from this cell that holds the experience in “mining” to be copied and inputted into the tender template in Google Docs
Thanks
Alison