I have connected my Google Sheets to Zapier and successfully retrieved the last row in the trigger section. Now, I want to send the entire row as a single JSON object or form data to my API (or another application) in the Action section—without using Zapier Formatter or Zapier Code.
I tried assigning {{bundle.inputData}} in the request body, but I keep receiving an empty array.
How can I properly pass the data from Google Sheets to my API? Any guidance would be appreciated!
+14Hi
It is not clear which app you are using for the API request.
Post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.
Resources for using app APIs in Zaps:
+6Hi
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Thank you guys for your response, this is my exact issue that i am facing.
bundle.inputData to pass the entire row data, but it is not appearing in the web-hook request.I am not using any any field mapping, is it necessary to always map data from excel to proceed further?
Hi
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Can you help me directly though a zoom call or google meet for 10 minutes only. that would be appreciated. i know you can help me i am just stuck on simple issue.
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
+6Hi
Your issue stems from data not transferring correctly from the Google Sheets trigger to your non-published application action. Ensure your data mapping is correct, your non-published app is set up to receive data correctly, and your request body contains the proper key. Use Zapier’s “Test this step” feature to pinpoint where the problem occurs. If the issue persists, contacting Zapier Support to create a resolution with the case.
Hi
Your issue stems from data not transferring correctly from the Google Sheets trigger to your non-published application action. Ensure your data mapping is correct, your non-published app is set up to receive data correctly, and your request body contains the proper key. Use Zapier’s “Test this step” feature to pinpoint where the problem occurs. If the issue persists, contacting Zapier Support to create a resolution with the case.
Thanks for your response
+6Hi
I'm glad to hear that you've found a resolution with the help of Zapier support! Indeed, when transferring data from Google Sheets or Excel to a non-published application, mapping the data is crucial to ensure the correct data is sent to your API in the right format. As you've discovered, you can't send all the raw data directly. Instead, you need to specify which column in your Google Sheets or Excel corresponds to which field in your API. This mapping process ensures that the data from each column is sent to the correct place in your API.
Remember, the "Test this step" feature in Zapier is a great tool to confirm that your data mapping is working as expected.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.