Discussions

We receive Google Sheets in our inbox from various people. We would like to extract these Google Sheets from the emails and copy them into another Google Drive folder. The problem is that Google Sheets (and other Google Docs) don’t appear as attachments since they are not actual files. Can you please let me know if we can do this using Zenphi?

Hi, Is there a way in Zenphi to extract the document id (file id) of a Google Sheets or a Google Docs from the url? The user uses a Zenphi form to submit the file URL along with other information. I don't want to ask the user to enter the file id as well and would rather find a way to extract it form the url.

We have created a Processor on Doc AI of Google. This has better extraction of documents & as per our requirement. Now we want to use the same processor (created on GCP) within Zenphi flow. Rest all steps will be same as before. We have referred to this - <https://docs.zenphi.com/docs/http-call> This is not taking the GCP URL of our processor, not sure what we are missing? Can you share a detailed steps for above.? a video explanation is better.

Hello, I'll attach a sample workflow to the comments of this board to demonstrate what I'm seeing. Basically, there's something I may be understanding with how the IN operator works. The workflow does the following: Sets value of variable to "a" Sets value of list to ["a", "b"] Checks if variable in list. If not, print FALSE; If true, print TRUE. The workflow prints FALSE, which is not what I expect. Could you help me understand? Thanks!

When trying to publish a workflow, I get the following error: Unable to register Google Forms trigger. The error from Google is: Exception: This script has too many triggers. Triggers must be deleted from the script before more can be added.. The user account used was: [[email protected]] I imagine this is related to limitations within Google on the number of triggers an Apps Script file can have. Is that the case? Is there a way to resolve this? How is a trigger defined (e.g. the number of Google functions in a workflow?)?. <br>

Hi, I keep getting the following error when one of the action in my zenphi flow executes. _System.Collections.Generic.KeyNotFoundException The given key '5155385686097920' was not present in the dictionary._ How do I fix it?

Hi, when i want to publish my zenphi Flow which has a Google Forms trigger, the browser goes into a loop and eventually errors. can you please help me?

Hi. Approval Task has a Comment outcome. How can one supply this comment via email? Web?

Zenphi now has the ability to ‘re-run’ a flow instance using the same trigger data. This means, for example, while building and testing a flow that starts with a Google Form submission, you no longer have to keep filling out a new Form each time you want to test your flow. Just locate a previous flow instance from the recent runs tab, click on it to view the details then click the re-run button. This will start a new flow instance using the same trigger data but using the latest published version of the flow. Hopefully this will save some time when working with lengthy Google Forms. This also works with all other triggers! [block:image] { "images": [ { "image": [ "https://www.linkpicture.com/q/71.jpeg", null, "" ], "align": "center" } ] } [/block]

Google Forms is a great way to quickly generate a web form to collect information. However, if your form includes a file upload field, the Form must be saved to your Personal Drive folder and any files that are uploaded in Form submissions are saved in the same location. This becomes a nuisance for organisations wanting to use Forms as we usually want form submissions saved to a Shared Drive location. Luckily, this can be easily achieved using zenphi. Create a Flow using a Forms trigger and configure it to start whenever your Form is submitted. Inside the Flow, drag on a ‘Foreach Loop’. Next drag on a Move Item action inside the loop. [block:image] { "images": [ { "image": [ "https://www.linkpicture.com/q/67.png", null, "" ], "align": "center" } ] } [/block] Configure the Foreach Loop to iterate over the collection of files that are submitted with the Form. To do this, select the Trigger->(File Upload form field). [block:image] { "images": [ { "image": [ "https://www.linkpicture.com/q/68.png", null, "" ], "align": "center" } ] } [/block] Next, configure the Move Item to move each uploaded file in the form to a folder in a Shared Drive. [block:image] { "images": [ { "image": [ "https://www.linkpicture.com/q/69_3.jpeg", null, "" ], "align": "center" } ] } [/block] In the File or folder field, select the ID of the file in the Foreach Loop action. Set your destination location using the Drive picker. [block:image] { "images": [ { "image": [ "https://www.linkpicture.com/q/70_12.png", null, "" ], "align": "center" } ] } [/block] And that’s it. You will need to repeat this for each File Upload field you have in your Google Form. You could also create a new Folder for each submission at the start of the Flow and store the files in subfolders if necessary.