Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi ​@Sumit Kumar Yadav 

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: 

 

Hi ​@Sumit Kumar Yadav,


 
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.

  • When i test run my action of connected to my sheets, I see data in my Google Sheets trigger step.
  • Then i connect my non published application to action step select my action to create.
  • But when i go on test section , i see no data  in Data In section.
  • I just added one key in my request body and added value to be {{bundel.inputData}} to get all data of previous trigger section to that key, But i am getting no data in Data in of my action section.
  • I expected 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 ​@Sumit Kumar Yadav,


 
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.

Hi ​@Sumit Kumar Yadav,

 

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 ​@Sumit Kumar Yadav,

 

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 ​@JammerS , i got resolution from zapier support, issue is i cant directly access all the data of excel in raw and directly send all data to my api. i have to map the data.

Hi ​@Sumit Kumar Yadav,

 

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.

Terms & Conditions