Hello! I know there is the built-in trigger “column change”, but does anyone know if I can build any type of automation (either via automation panel or API) when I change / update a monday doc of an item? It seems that using “column change” only works for monday doc / file columns if I add or remove files from the column but not actually updating anything internally in the document. Am I missing something?
Hey @Daniel.prudente
Yes, there is a solution to your problem. Though not directly but via API. You can use the Query for documents for accessing document.
query {
docs (object_ids: 123456789, limit: 1) {
id
object_id
settings
created_by {
id
name
}
}
}
And to discuss the Document content use the following query:
query {
docs (object_ids: 123456789, limit: 1) {
id
object_id
settings
created_by {
id
name
}
}
}
In case you need any help setting it up let me know here and I’ll be happy to assist.
Zaki
Business Workflow Consultant
Hey @ZakiImtiaz , thanks for your reply.
Indeed, I already use this query returning some additional fields and that’s my issue with not having a trigger. I need to check every change in the doc and update a sheet. So, I would usually have a trigger to let me know whenever a doc of my board was updated, and using a webhook running this query. As I couldn’t find any trigger, I have to run this query every two minutes in all my items’ docs to check if any of them were updated…it’s very cumbersome without a trigger.
Internally, Monday has not provided any automation that deals with Monday Docs’ Updates. Even with the external tools don’t provide any such automation trigger. Neither does API work n this regard.
However, there could be one thing that might work. In make.com there is a Monday.com automation Trigger that is able to fetch files attached in monday.com after regular intervals, that can be used to get the output.
Theoretical Structure:
Automation 1
- Trigger: Column Update (when file attached)
- Action: get the file content and save it temporarily at a space.
Automation 2
- Trigger: Get list of files (at regular intervals)
- Action: Compare the content of each file with the previous content.
- Condition: if there has been an update.
- Action: Reflect the update in Monday.com
This is a rough sketch of how it might work. it might be not the most optimal situation. Before working on it, remember it might require API calling and AI as well. So make sue if the hassle is even worth it.
In case you need any help setting it up let me know here and I’ll be happy to assist.
Zaki
Business Workflow Consultant
Thanks for the detailed explanation, @ZakiImtiaz! This is the structure I’m currently doing , but instead of Make triggers, I’m using webhook via Google Sheets Appscript.