Runtime error (404)

[Charlie_Kleiner]

I’m getting a runtime error when trying to run my scenario. Here’s what’s happening.

I’m using a webhook to send information to Make each time a new row is added to a google sheet. When I add the first (new) row of data to my sheet, the flow works and I’m sent an email (as expected). However, when I add the second row of data, I then get this error ([404] File not found: {“authMode”:{},“week-of-year”:25,“day-of-week”:3,“month”:6,“hour”:18,“year”:2025,“timezone”:“UTC”,“day-of-month”:18,“triggerUid”:“2290021962”,“minute”:3,“second”:39}.)

QCT Certificate Send.blueprint.json

The output bundle just shows [null]

Here is the input bundle:
[
{
“file”: “{"authMode":{},"week-of-year":25,"day-of-week":3,"month":6,"hour":17,"year":2025,"timezone":"UTC","day-of-month":18,"triggerUid":"2290021962","minute":53,"second":39}”,
“select”: “map”,
“formatDrawings”: “image/jpeg”,
“formatDocuments”: “application/vnd.openxmlformats-officedocument.wordprocessingml.document”,
“formatSpreadsheets”: “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,
“formatPresentations”: “application/pdf”
}
]

[Trainward_Consulting]

Hi @Charlie_Kleiner,

One observation I’ve made is that in your input bundle there’s nothing that represents “fileId”, the datapill from the webhook you’ve put in your Google Drive step. Can you see if there’s a difference between the input bundle from the first row compared to the second row?

-@Trainward_Consulting

[Charlie_Kleiner]

Thanks for the response! I was able to re-run a successful flow. Here’s what the input and output bundles look like for a successful run.

Input bundle:

[
{
“file”: “1PyT6F37yqOye0vTXUOCCtorejVSig1KN”,
“select”: “map”,
“formatDrawings”: “image/jpeg”,
“formatDocuments”: “application/vnd.openxmlformats-officedocument.wordprocessingml.document”,
“formatSpreadsheets”: “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,
“formatPresentations”: “application/pdf”
}
]

Output bundle:
[
{
“kind”: “drive#file”,
“id”: “1PyT6F37yqOye0vTXUOCCtorejVSig1KN”,
“name”: “serdgfg_test_Certificate.pdf”,
“mimeType”: “application/pdf”,
“starred”: false,
“trashed”: false,
“explicitlyTrashed”: false,
“parents”: [
“1NPxS0dRgsOtsdw_u01cCzyAw_37kjztY”
],
“spaces”: [
“drive”
],
“version”: “1”,
“webContentLink”: “https://drive.google.com/uc?id=1PyT6F37yqOye0vTXUOCCtorejVSig1KN&export=download”,
“webViewLink”: “https://drive.google.com/file/d/1PyT6F37yqOye0vTXUOCCtorejVSig1KN/view?usp=drivesdk”,
“iconLink”: “https://drive-thirdparty.googleusercontent.com/16/type/application/pdf”,
“hasThumbnail”: false,
“thumbnailVersion”: “0”,
“viewedByMe”: true,
“viewedByMeTime”: “2025-06-18T22:52:36.795Z”,
“createdTime”: “2025-06-18T22:52:36.795Z”,
“modifiedTime”: “2025-06-18T22:52:36.795Z”,
“modifiedByMeTime”: “2025-06-18T22:52:36.795Z”,
“modifiedByMe”: true,
“owners”: [
{
“kind”: “drive#user”,
“displayName”: “Charlie Kleiner”,
“photoLink”: “https://lh3.googleusercontent.com/a/ACg8ocLukWufHlCDuAMlaNSlGzaDZkfAhYa7nIp1FbhNq16Pt4C2wQ=s64”,
“me”: true,
“permissionId”: “13989869846831750145”,
“emailAddress”: “charlie.kleiner@quizlet.com”
}
],
“lastModifyingUser”: {
“kind”: “drive#user”,
“displayName”: “Charlie Kleiner”,
“photoLink”: “https://lh3.googleusercontent.com/a/ACg8ocLukWufHlCDuAMlaNSlGzaDZkfAhYa7nIp1FbhNq16Pt4C2wQ=s64”,
“me”: true,
“permissionId”: “13989869846831750145”,
“emailAddress”: “charlie.kleiner@quizlet.com”
},
“shared”: false,
“ownedByMe”: true,
“capabilities”: {
“canAcceptOwnership”: false,
“canAddChildren”: false,
“canAddMyDriveParent”: false,
“canChangeCopyRequiresWriterPermission”: true,
“canChangeSecurityUpdateEnabled”: false,
“canChangeViewersCanCopyContent”: true,
“canComment”: true,
“canCopy”: true,
“canDelete”: true,
“canDisableInheritedPermissions”: false,
“canDownload”: true,
“canEdit”: true,
“canEnableInheritedPermissions”: true,
“canListChildren”: false,
“canModifyContent”: true,
“canModifyContentRestriction”: true,
“canModifyEditorContentRestriction”: true,
“canModifyOwnerContentRestriction”: true,
“canModifyLabels”: false,
“canMoveChildrenWithinDrive”: false,
“canMoveItemIntoTeamDrive”: true,
“canMoveItemOutOfDrive”: true,
“canMoveItemWithinDrive”: true,
“canReadLabels”: false,
“canReadRevisions”: true,
“canRemoveChildren”: false,
“canRemoveContentRestriction”: false,
“canRemoveMyDriveParent”: true,
“canRename”: true,
“canShare”: true,
“canTrash”: true,
“canUntrash”: true
},
“viewersCanCopyContent”: true,
“copyRequiresWriterPermission”: false,
“writersCanShare”: true,
“permissions”: [
{
“kind”: “drive#permission”,
“id”: “13989869846831750145”,
“type”: “user”,
“emailAddress”: “charlie.kleiner@quizlet.com”,
“role”: “owner”,
“displayName”: “Charlie Kleiner”,
“photoLink”: “https://lh3.googleusercontent.com/a/ACg8ocLukWufHlCDuAMlaNSlGzaDZkfAhYa7nIp1FbhNq16Pt4C2wQ=s64”,
“deleted”: false,
“pendingOwner”: false
}
],
“permissionIds”: [
“13989869846831750145”
],
“originalFilename”: “serdgfg_test_Certificate.pdf”,
“fullFileExtension”: “pdf”,
“fileExtension”: “pdf”,
“md5Checksum”: “ceb8ad9f50377a2af9dc8c19a74dcd9f”,
“sha1Checksum”: “c905ede40ebcc21f3e392da18f5eece069fd96c8”,
“sha256Checksum”: “199d90b01dabb3370ab646a0c09d4199d7d6c1fd35c6dcf304b32562522e6364”,
“size”: “18367”,
“quotaBytesUsed”: “18367”,
“headRevisionId”: “0Byb7KJz4_T51WVNOTVcwcTMxSUpibS94R1lzMktta0JsVjRRPQ”,
“isAppAuthorized”: false,
“linkShareMetadata”: {
“securityUpdateEligible”: false,
“securityUpdateEnabled”: true
},
“inheritedPermissionsDisabled”: false,
“data”: “IMTBuffer(18367, binary, c905ede40ebcc21f3e392da18f5eece069fd96c8): 255044462d312e340a2520e2e3cfd30a330a300a6f626a0a3c3c0a2f547970650a2f436174616c6f670a2f4e616d65730a3c3c0a3e3e0a2f506167654c6162656c730a3c3c0a2f4e756d730a5b0a300a3c3c0a2f530a2f440a2f53740a310a3e3e0a5d0a”,
“filesize”: 18367
}
]

[Trainward_Consulting]

Thanks for providing this info. You’re fileId in your first bundle looks completely different thant he fileID provided in the second bundle:

Bundle from First Row
{
“file”: “1PyT6F37yqOye0vTXUOCCtorejVSig1KN”,
“select”: “map”,
“formatDrawings”: “image/jpeg”,
“formatDocuments”: “application/vnd.openxmlformats-officedocument.wordprocessingml.document”,
“formatSpreadsheets”: “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,
“formatPresentations”: “application/pdf”
}

Bundle from Second Row
{
“file”: “{“authMode”:{},“week-of-year”:25,“day-of-week”:3,“month”:6,“hour”:17,“year”:2025,“timezone”:“UTC”,“day-of-month”:18,“triggerUid”:“2290021962”,“minute”:53,“second”:39}”,
“select”: “map”,
“formatDrawings”: “image/jpeg”,
“formatDocuments”: “application/vnd.openxmlformats-officedocument.wordprocessingml.document”,
“formatSpreadsheets”: “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,
“formatPresentations”: “application/pdf”
}

Apologies because I think you already knew this information. I think this suggests that there’s some variability on how the payloads are being generated and sent to Zapier. Is there a reason you’re not using the Google Sheets connector in Make and watching for New Rows? (Pictured)

[samliew]

Looks like the script sending the data to the webhook has been incorrectly configured, and it’s not an issue with the scenario itself.

Hope this helps!

— @samliew