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.

Best answer

How can I get data not in JSON format when sending data from Google Sheets to SuiteDash?

  • June 24, 2022
  • 8 replies
  • 212 views
I

Hello , i have a little problem and would like to get help , the problem is when i use Schedule to automate getting data from google sheets and send the received data to SuiteDash , in action google sheets i select event “Get many spreadSheet Rows” and  i am getting data in a array in json format with key and value , how can I get data not in json format ? , because I can't exploit the data in json format to populate fields .

 

Any help or ideas? Thanks!

Best answer by Danvers

Hi @immoinov.fr!

Just checking back in on this one! As @christina.d mentioned, we don’t seem to have a ticket from the email address associated with your Zapier Community account, so unless you sent the request from a different email address, you may need to send the ticket again if you still need some additional help. 

 

I also want to call back to @Troy Tessalone’s response here, because he’s right on the money. If you use the ‘Find Many Spreadsheet Rows’ search instead of ‘Get Many Spreadsheet Rows’, the information from Google Sheets will be returned as line items, rather than JSON. The limit with that action is that it can only return up to 10 rows that match the search. If you have more than 10 rows that might match, then you will need to use the Get Many Spreadsheet Rows action and then use a code step to parse the data in a way that will work for Suitdash. 

 

So to sum up: if you have less than 10 rows, use Find Many Spreadsheet Rows, if you have more than 10 rows you’ll need to stick with the ‘Get’ search and add a step to format the data in the way that you need it. 

 

I hope that helps, let us know if you have any questions!

    This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

    8 replies

    Troy Tessalone
    Zapier Orchestrator & Solution Partner
    Forum|alt.badge.img+14
    • Troy TessaloneZapier Orchestrator & Solution Partner
    • Zapier Orchestrator & Solution Partner
    • June 24, 2022

    Hi @immoinov.fr 

    Good question.

    Try the GSheet Find Row(s) Zap action, but that will only return 10 rows MAX.

     

    A better alternative is to use Airtable.

    Airtable has APIs that can return up to 100 records per page.

    https://airtable.com/api

    ⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
    I
    • immoinov.frBeginner
    • Author
    • Beginner
    • June 24, 2022

    Hey @Troy Tessalone !

    Thank you very much for your quick reply , i gonna try do this with Airtable.

    jesse
    Forum|alt.badge.img+9
    • jesseArchitect
    • Architect
    • June 27, 2022

    Hey @immoinov.fr! Just checking in: How did things go with Airtable? Were you able to get to your desired outcome here? We’re also big fans of Airtable so I am curious to see how you’re doing with getting things set up there. Let us know!

    I
    • immoinov.frBeginner
    • Author
    • Beginner
    • June 29, 2022

    Hey @jesse end @Troy Tessalone Thank you for your replied,

    for explaining the situation, we have created a robot that will scrap the information that will be stored in a google sheet and re-display the information in suitedash to each customer, now the problem is that I would like to automate all this and suitedash uses zapier to retrieve the data, but each time I put the "schelude" trigger + google sheet the information does not come out when json and when I put the data in json in suitedash, the data is displayed in json. Is there a way that my data does not come out in json?

     

    jesse
    Forum|alt.badge.img+9
    • jesseArchitect
    • Architect
    • July 5, 2022

    Hey @immoinov.fr thanks for elaborating! Hmm, I’m actually not sure on this one. Any ideas, @Troy Tessalone? 

    @immoinov.fr you might also want to create a ticket with our support team as they may be able to dig into this one a bit further and offer some suggestions: https://zapier.com/app/get-help

    Keep us posted with if you’re able to get that data to output in non-JSON format!

      I
      • immoinov.frBeginner
      • Author
      • Beginner
      • July 6, 2022

      Hey @jesse , thanks for your reply , I already created a ticket 2 weeks ago, but  I did not receive any response from your team.

      christina.d
      Forum|alt.badge.img+9
      • christina.dZapier Staff
      • Zapier Staff
      • July 11, 2022

      Oh no, @immoinov.fr! I’m sorry to hear that! Did you send it from the email associated with your community account? If you did, I don’t see an associated ticket with it unfortunately. 😔

      If you did and you’re still not seeing a response, I might recommend checking your spam/junk folder in case it’s ended up there by mistake. If it's not there I recommend searching your whole email inbox for emails ending in ‘@zapier.com’. 
       

      Please keep us posted! 

      Danvers
      Forum|alt.badge.img+12
      • DanversZapier Staff
      • Zapier Staff
      • Answer
      • July 21, 2022

      Hi @immoinov.fr!

      Just checking back in on this one! As @christina.d mentioned, we don’t seem to have a ticket from the email address associated with your Zapier Community account, so unless you sent the request from a different email address, you may need to send the ticket again if you still need some additional help. 

       

      I also want to call back to @Troy Tessalone’s response here, because he’s right on the money. If you use the ‘Find Many Spreadsheet Rows’ search instead of ‘Get Many Spreadsheet Rows’, the information from Google Sheets will be returned as line items, rather than JSON. The limit with that action is that it can only return up to 10 rows that match the search. If you have more than 10 rows that might match, then you will need to use the Get Many Spreadsheet Rows action and then use a code step to parse the data in a way that will work for Suitdash. 

       

      So to sum up: if you have less than 10 rows, use Find Many Spreadsheet Rows, if you have more than 10 rows you’ll need to stick with the ‘Get’ search and add a step to format the data in the way that you need it. 

       

      I hope that helps, let us know if you have any questions!

      Terms & ConditionsAccessibility statement