Google Forms Trigger not pulling data from response to name new files

[Crw06]

Hello I created a session to create a new GDrive folder, new google sheets created from templates, new slack channel and new clickup folder all with the name of the brand provided in the google form response.

But it creates the items without the brand name (folder, google sheets, Slack channel are created but the Clickup task gets error below - I think bc it only has the dynamic part and nothing else)

Is there an error in Make collecting the data from Google Form? Something I left unchecked? It asks in the trigger how many responses to process at once so that’s set at 2 but I figured that’d be 2 actual forms filled out by 2 different people not amount of questions to process?

Error log:

[Automate_with_Rezwan]

@Crw06 Can you please export the scenario and provide me it’s blueprint? As even if it’s dynamic the name should go on to Clickup.

Or you can provide a loom video of the error.

[samliew]

Welcome to the Make community!

@Crw06

The module with the error is not shown in this screenshot

Module [12] is cropped out at the bottom.

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

^{(Note: Exporting your scenario will not include private information or keys to your connections)}

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[Crw06]

@samliew @Automate_with_Rezwan thanks so much, here is more info:
blueprint.json (77.9 KB)

Here is what is supposed to be input for create Slack Channel (it creates the channel named “c-” but doesn’t append brand name from the form):

Here is what is going in - maybe the private setting here needs to be fixed in forms?

But I dont see it as being private:

Here is the variable that is supposed to be copied within the completed form response:

Link to quiz: WGM Onboarding Form

Here is bundle input/output for Clickup task

Here is bundle output for the create Drive folder

[
{
“kind”: “drive#file”,
“id”: “17r5Y9zDyXDpo1cDv1yU7WhrQkkch5qCP”,
“name”: “New Folder”,
“mimeType”: “application/vnd.google-apps.folder”,
“starred”: false,
“trashed”: false,
“explicitlyTrashed”: false,
“parents”: [
“1DOzgqN7Fo_9JiG39OQVTAXY4iriRZy5z”
],
“spaces”: [
“drive”
],
“version”: “1”,
“webViewLink”: “New Folder - Google Drive”,
“iconLink”: “https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.folder+48”,
“hasThumbnail”: false,
“thumbnailVersion”: “0”,
“viewedByMe”: false,
“createdTime”: “2023-12-09T17:36:22.322Z”,
“modifiedTime”: “2023-12-09T17:36:22.322Z”,
“modifiedByMeTime”: “2023-12-09T17:36:22.322Z”,
“modifiedByMe”: true,
“owners”: [
{
“kind”: “drive#user”,
“displayName”: “Charles Warren”,
“photoLink”: “https://lh3.googleusercontent.com/a/default-user=s64”,
“me”: true,
“permissionId”: “14133835738621459231”,
“emailAddress”: “support@warrengrowthmarketing.com”
}
],
“lastModifyingUser”: {
“kind”: “drive#user”,
“displayName”: “Charles Warren”,
“photoLink”: “https://lh3.googleusercontent.com/a/default-user=s64”,
“me”: true,
“permissionId”: “14133835738621459231”,
“emailAddress”: “support@warrengrowthmarketing.com”
},
“shared”: true,
“ownedByMe”: true,
“capabilities”: {
“canAcceptOwnership”: false,
“canAddChildren”: true,
“canAddMyDriveParent”: false,
“canChangeCopyRequiresWriterPermission”: false,
“canChangeSecurityUpdateEnabled”: false,
“canChangeViewersCanCopyContent”: false,
“canComment”: true,
“canCopy”: false,
“canDelete”: true,
“canDownload”: true,
“canEdit”: true,
“canListChildren”: true,
“canModifyContent”: true,
“canModifyContentRestriction”: false,
“canModifyEditorContentRestriction”: false,
“canModifyOwnerContentRestriction”: false,
“canModifyLabels”: false,
“canMoveChildrenWithinDrive”: true,
“canMoveItemIntoTeamDrive”: true,
“canMoveItemOutOfDrive”: true,
“canMoveItemWithinDrive”: true,
“canReadLabels”: false,
“canReadRevisions”: false,
“canRemoveChildren”: true,
“canRemoveContentRestriction”: false,
“canRemoveMyDriveParent”: true,
“canRename”: true,
“canShare”: true,
“canTrash”: true,
“canUntrash”: true
},
“viewersCanCopyContent”: true,
“copyRequiresWriterPermission”: false,
“writersCanShare”: true,
“permissions”: [
{
“kind”: “drive#permission”,
“id”: “14133835738621459231”,
“type”: “user”,
“emailAddress”: “support@warrengrowthmarketing.com”,
“role”: “owner”,
“displayName”: “Charles Warren”,
“photoLink”: “https://lh3.googleusercontent.com/a/default-user=s64”,
“deleted”: false,
“pendingOwner”: false
},
{
“kind”: “drive#permission”,
“id”: “anyoneWithLink”,
“type”: “anyone”,
“role”: “reader”,
“allowFileDiscovery”: false
}
],
“permissionIds”: [
“14133835738621459231”,
“anyoneWithLink”
],
“folderColorRgb”: “#8f8f8f”,
“quotaBytesUsed”: “0”,
“isAppAuthorized”: true,
“linkShareMetadata”: {
“securityUpdateEligible”: false,
“securityUpdateEnabled”: true
}
}
]

[Automate_with_Rezwan]

@Crw06 the answers from the Google form were mapped incorrectly. Please follow this format to properly map the value of the answer

[Crw06]

@Automate_with_Rezwan I updated everything to add the value and it still is not finding it. I think the key is with it being “private” maybe?

[Crw06]

No nevermind, that is making the channel private in Slack. It is just not picking up anything from forms

[Si]

Hello, just stumbled on this. What might be the problem here is that the answer value is part of an array of collections (a list of all answers tied to all of the questions) and is therefore not being “parsed” to the desired output which in your case mimics a text concatenation (naming folders, etc)

As stated before I would try to map the value differently using the MAP and GET built in functions (without increasing the number of used operations). There is a great youtube video on this by @Msquare_Automation https://youtu.be/QGhuNDxWIDE?si=JaVoGUR_C86bDfH2.

EDIT: also found this in line with my explanation (from Make): https://www.make.com/en/help/tutorials/extract-an-item-and-or-its-value-from-an-array-of-collections

Hope it helps!

[Crw06]

I don’t get it so Google Forms isn’t an acceptable trigger for this, it would need to be done with JSON @Si ?

[Si]

Not sure what you mean by that.

But google form does return an array of answers, therefore you need to extract the specific value in the array before using it as e.g. plain text in your other operations (as you said - naming the folder). This is where Make is no completely “no-code”, but a basic understanding of programs is necessary as the operation will not simply extract text from an array unless you specify it how and where to.

How to do it is explained in my previous post and is actually pretty easy, dos not need to work with any specific JSON etc.
Example (you can copy paste and add your values):

{{get(map(Name (//of the question fields); "value";//additional filter - see documentation;); 1)}}

p.s. if you use ChatGPT or similar you could simply copy the form output bundle (from Make) and ask it to provide the formula for what you want to extract. It will probably be at least very close to the desired result without needing any additional “coding”.