# BlockSpring Help

**URL:** <https://forum.bubble.io/t/blockspring-help/394>\
**Category:** Need help\
**Created:** [October 16, 2015, 8:48pm UTC](https://forum.bubble.io/t/blockspring-help/394 "2015-10-16T20:48:44Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 16, 2015, 8:48pm UTC](https://forum.bubble.io/t/blockspring-help/394/1 "2015-10-16T20:48:44Z")

</div>

I just noticed that BlockSpring is now available as a plugin, very exciting!!!  
But, I can’t quite figure out how to use it in Bubble. I’ve setup a test and with BlockSpring’s Google Spreadsheet query. I want to display those results on a group repeater but to no avail. The one thing that really confuses me is the “Data Type” settings for the BlockSpring Plugin, there’s a Product and Price but those aren’t necessarily types that could be returned from the BlockSpring Google Sheet Query. Can you explain that and how I should go about displaying a BlockSpring data return on Bubble?  
I’ve uploaded a .gif of my settings and can’t figure out what else I could do to display that query. ![](https://us1.discourse-cdn.com/bubble/original/1X/10230eada0f0d19b0b6a934678723a1721256bbd.gif)

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 16, 2015, 10:38pm UTC](https://forum.bubble.io/t/blockspring-help/394/2 "2015-10-16T22:38:30Z")

</div>

(the Blockspring plugin is still under development, and we’re actively working with the Blockspring team to fix some aspects - disclaimer ;))

The general spirit is that Blockspring returns, in edit mode, a description of the values you’re getting back from the block, and that’s what we have in the data type popup. This is a way to enable people to refine types if the types aren’t set properly.

Looking at your app (the gif), it looks fine Bubble-wise, the issue is more in what returns blockspring with this block. Can you try in their console and see if it works. If so, paste a result sample here and we’ll take it from there.

---

<div class="post-metadata">

**Author:** ![NicolasDap](https://avatars.discourse-cdn.com/v4/letter/n/c2a13f/32.png) [@NicolasDap](https://forum.bubble.io/u/NicolasDap)\
**Post date:** [October 17, 2015, 11:26am UTC](https://forum.bubble.io/t/blockspring-help/394/3 "2015-10-17T11:26:52Z")

</div>

This new integration brings so many new possibilites. Great job here, really !

If I create my own blocks (located in Blockspring’s Favorites) with specific inputs, can I add it in my Bubble’s list of blocks ?  
I just did a test and I couldn’t find it the plugin’s list. Or it’s under development maybe.

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 17, 2015, 12:09pm UTC](https://forum.bubble.io/t/blockspring-help/394/4 "2015-10-17T12:09:45Z")

</div>

It should, though I can’t confirm this yet (it’s actually a question for the Blockspring side). We’ll check.

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 17, 2015, 8:28pm UTC](https://forum.bubble.io/t/blockspring-help/394/5 "2015-10-17T20:28:10Z")

</div>

So we don’t have that returned yet, but we’ll have in a few days.

---

<div class="post-metadata">

**Author:** ![NicolasDap](https://avatars.discourse-cdn.com/v4/letter/n/c2a13f/32.png) [@NicolasDap](https://forum.bubble.io/u/NicolasDap)\
**Post date:** [October 18, 2015, 9:28am UTC](https://forum.bubble.io/t/blockspring-help/394/6 "2015-10-18T09:28:07Z")

</div>

All right. That’s great because I saw some additionnal interesting blocks in [open.blockspring.com/browse](http://open.blockspring.com/browse) which are not listed with the defaut API list.

---

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 18, 2015, 10:21pm UTC](https://forum.bubble.io/t/blockspring-help/394/8 "2015-10-18T22:21:24Z")

</div>

I was just using the default block setting for GoogleSheets. If I run it in BlockSpring it works fine.  
The google Sheet url is [https://docs.google.com/spreadsheets/d/1Wl3Ad\_Y\_izZM8J5UizPbAMuOZGpb2FzAZfbAJ-aU2Tc/edit#gid=779395260](https://docs.google.com/spreadsheets/d/1Wl3Ad_Y_izZM8J5UizPbAMuOZGpb2FzAZfbAJ-aU2Tc/edit#gid=779395260)

And the query parameter I had was Select \*

When I run those parameters at [https://open.blockspring.com/donpinkus/query-google-spreadsheet](https://open.blockspring.com/donpinkus/query-google-spreadsheet) It returns data fine

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 19, 2015, 2:21am UTC](https://forum.bubble.io/t/blockspring-help/394/9 "2015-10-19T02:21:10Z")

</div>

Can share a link to your app in run mode?

---

<div class="post-metadata">

**Author:** ![NicolasDap](https://avatars.discourse-cdn.com/v4/letter/n/c2a13f/32.png) [@NicolasDap](https://forum.bubble.io/u/NicolasDap)\
**Post date:** [October 19, 2015, 8:41am UTC](https://forum.bubble.io/t/blockspring-help/394/11 "2015-10-19T08:41:19Z")

</div>

@Blake. I would like to be able to import lists of Products. I tried like you did but did not succeed.

Here my test on the public forum’s app anyone can edit :

> **[Bubble Editor - Forum\_app](https://bubble.io/page?type=page&name=15_10_19 __need_help__ ndap&id=forum_app&tab=tabs-1)**
>
> Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

May we do the change in this page so we can all get the solution.

---

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 19, 2015, 1:52pm UTC](https://forum.bubble.io/t/blockspring-help/394/12 "2015-10-19T13:52:17Z")

</div>

Here you go, let me know if this will work for you.

> **[Bubble Editor - blakeblockspring](https://bubble.io/page?name=index&id=blakeblockspring&tab=tabs-1)**
>
> Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

---

<div class="post-metadata">

**Author:** ![NicolasDap](https://avatars.discourse-cdn.com/v4/letter/n/c2a13f/32.png) [@NicolasDap](https://forum.bubble.io/u/NicolasDap)\
**Post date:** [October 19, 2015, 1:55pm UTC](https://forum.bubble.io/t/blockspring-help/394/13 "2015-10-19T13:55:33Z")

</div>

I can’t see anything actually

---

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 19, 2015, 3:00pm UTC](https://forum.bubble.io/t/blockspring-help/394/14 "2015-10-19T15:00:01Z")

</div>

Sorry, this link should do it… [https://bubble.io/page?name=index&id=blakeblockspring&tab=tabs-1](https://bubble.io/page?name=index&id=blakeblockspring&tab=tabs-1)

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 19, 2015, 4:43pm UTC](https://forum.bubble.io/t/blockspring-help/394/15 "2015-10-19T16:43:30Z")

</div>

That’s an issue on our end when you’re using the default value that blockspring gives (here the URL). We’ll deploy a fix today. But you use your own sheet that should work fine.

---

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 19, 2015, 6:49pm UTC](https://forum.bubble.io/t/blockspring-help/394/16 "2015-10-19T18:49:02Z")

</div>

I replaced the Google Sheets url with one I created ( [https://docs.google.com/spreadsheets/d/1V5-y6w6AjEjW0in\_BuBomrMCMIeFzHWhkoxnIaWFJM4/edit#gid=0](https://docs.google.com/spreadsheets/d/1V5-y6w6AjEjW0in_BuBomrMCMIeFzHWhkoxnIaWFJM4/edit#gid=0) ), tested it in BlockSpring (worked fine) and entered it in my project but no go.

For what it’s worth I copied the inspector from that element and what’s peculiar is that the Product and Price show up empty:

\*EvaluatorQuery Google SpreadsheetAPI providerQuery Google SpreadsheetQuerySELECT _URLhttps://docs.google.com/spreadsheets/d/1V5-y6w6AjEjW0in\_BuBomrMCMIeFzHWhkoxnIaWFJM4/edit#gid=0Query Google Spreadsheet: Query Google Spreadsheet - 0: **Product: (empty) Price: (empty)**_

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 19, 2015, 7:22pm UTC](https://forum.bubble.io/t/blockspring-help/394/17 "2015-10-19T19:22:24Z")

</div>

So the issue is that now the data type returned by blockspring is different because it’s a different sheet (no product/price in your sheet). I’ll check with the Blockspring team for that, the issue is on their end, as we retrieve the types dynamically, and their data isn’t up to date.

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 19, 2015, 7:27pm UTC](https://forum.bubble.io/t/blockspring-help/394/18 "2015-10-19T19:27:44Z")

</div>

On the other hand, if you have the columns Product/Price, you should be able to see your data.

---

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 19, 2015, 7:57pm UTC](https://forum.bubble.io/t/blockspring-help/394/19 "2015-10-19T19:57:01Z")

</div>

Yes indeed that worked when I added a Product and Price Column to the sheet!  
So if I understand right, ideally the product types should be dynamically displaying my column headers from the sheet?  
If so then that means we’d only be able to display two types of data from that specific BlockSpring?

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 19, 2015, 7:58pm UTC](https://forum.bubble.io/t/blockspring-help/394/20 "2015-10-19T19:58:26Z")

</div>

Yes, and that’s something that Blockspring will have to fix (so can’t promise when for this)

---

<div class="post-metadata">

**Author:** ![Blake](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/blake/32/65881_2.png) [@Blake](https://forum.bubble.io/u/Blake)\
**Post date:** [October 19, 2015, 8:05pm UTC](https://forum.bubble.io/t/blockspring-help/394/21 "2015-10-19T20:05:11Z")

</div>

Thank you!  
And to verify this API would be limited to two data types or Column Headers as it is in this case?

---

<div class="post-metadata">

**Author:** ![emmanuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/emmanuel/32/27657_2.png) [@emmanuel](https://forum.bubble.io/u/emmanuel)\
**Post date:** [October 19, 2015, 8:06pm UTC](https://forum.bubble.io/t/blockspring-help/394/22 "2015-10-19T20:06:15Z")

</div>

Well they should be able to have this dynamically, with as many columns as you have in your sheet, but again, this part isn’t really on our end.

[Next page](https://forum.bubble.io/t/blockspring-help/394.md?page=2)
