we’re using Google Drive to manage our shared files. At the same time, we’d like to have them listed in Monday as well, so the team has a single point of entry.
Our current approach is a dedicated board for documents, which only has a name and a file column. The file column links to the documents in Google Drive.
Now it’s additional work to add a new item manually for every new file in Drive. So I wanted to use zapier.com to build an automation that creates an item in the documents board in monday every time a new file is added to Drive. In Zapier I have a single field “Column Values” that takes a JSON structure. However, the linked developer docs did not give any information about how that structure should look like for adding an entry in the file column that links to GDrive the same way manually adding a file does.
Can you help me with this? Or is this currently not possible using the API?