Services Plugins FAQs

Need help with Google Sheets Service Account to pass Bubble data to Google Sheets

Plugins
#1

Hello @zeroqode2 @zeroqode1 @kate

Guys and girls, need help with the plugin which I am using inside the application. This one right here → Google Sheets & Charts (Service) Plugin | Bubble

Would recommend you to update the docs though - Google Sheets & Charts Service Plugin
The information is somewhat outdated, Google definitely changed quite some things on their side. :slight_smile:

Anyways I would like to know how can I send my database table from Bubble to Google Sheets?

I am using the Custom Google Sheets creation action on a Button event

Screenshot 2023-02-08 at 19.40.49
Screenshot 2023-02-08 at 19.40.491920×768 96.2 KB

I believe here I should write down the json or something ? I don’t know, nor there is info in docs on how to pass values from bubble to google sheets.
Where in this json body - Google Sheets & Charts Service Plugin I should write a dynamic expression with data from Bubble table?

Cause at the moment all I get is an empty sheet :frowning:

Screenshot 2023-02-08 at 19.46.17
Screenshot 2023-02-08 at 19.46.171920×1300 98 KB

Can you please provide instructions on this one? Thank you.

#2

Anyone here? @kate @Julia

Maybe there is a faster way to get support regarding a product?
Could you kindly tell me. Thank you.

cc @zeroqode

#3

Hello, @James.JJ.
Sorry, we have some workload here and it was impossible to get back to you faster. :pray:

It is quite a complicated question that can’t be answered shortly. Some solid understanding of Bubble platform and at least a slight experience of JSON are needed to achieve this goal.

To provide you with some guidelines and insights, I need some time to investigate your use case. I will get back to you once I have any updates.

By the way, can you please tell what exactly was not clear for you in the plugin documentation? We value your feedback and will appreciate your help on improving it.

Thanks :slightly_smiling_face:

#4

Hello @kate . Thanks for coming back to me :slight_smile:

Okay, considering the plugin does not provide a clear instruction on how to set it and the demo page also is not readable I thought maybe the team at zeroqode can provide help on the current plugin.

Surely the support knows what a JSON is and how the plugin works, so it shouldn’t take much time to provide a simple digestible response in due time :slight_smile:

Hope to hear from you soon. Thank you.

#5

Hello @kate hope you’re have a good end of week.

But I would appreciate some simple communication here, and a lil faster not waiting 20h to get a response related to a product.

Since the description says on plugin page

Screenshot 2023-02-10 at 15.37.20
Screenshot 2023-02-10 at 15.37.201664×1004 112 KB

Import and Export and even format Sheets data.

One would believe that the plugin offers such option, to import data from Bubble into Sheets via this plugin.
There is not clear instruction on how this is done - Google Sheets & Charts Service Plugin
Just a list of available actions which to be honest are not clear enough so I am lost in them. Tried pretty much everything and what I can assume is that the plugin misses a link between a Spreadsheet creation on behalf of application organization and sending an array of data to Spreadsheet.

So I am asking how can send data from bubble to google sheets. It should’ve been quite easy for support team considering they know the products or even someone from dev team can simply look at it and provide an answer.

I believe everyone will be grateful for this, and the plugin will be a real deal!

Thank you in advance for your support.

#6

Hello, @James.JJ.

Yes, our plugin allows this, by using the following plugin content.

Summary

Import Sheets data (PUT/POST requests):

image
image1278×1266 280 KB

image
image896×560 103 KB

Export Sheets data (GET request):

image
image1160×1018 214 KB

To make it easier to use the plugin without the need to create and modify (when needed) the {body} of each advanced action with the JSON formatted text, I can recommend you using simpler actions, such as:
Write a Column Sheet, if you need to fill in with the data into your spreadsheet column;
Write a Row to Sheet, if you need to create a new row in your speadsheet.

Important thing to note:

  • you should indicate the spreadsheet ID to make the plugin “understand” which document you want to modify;
    image
    image694×200 23 KB
  • the spreadsheet you are going to modify should have a public access or private access with the specific user granted access (your user, who is going to modify a spreadsheet);
    image
  • the data you are going to push into your spreadsheet should have a specific formatting. Each text string should be surrounded by [" some text "] symbols;
    image
  • if you are going to push a data from the database, which is a list of text strings, use the JOIN WITH operator in the following format - [" Search for DatabaseName:each item’s Data join with “], [” "] - Screenshot by Lightshot. It will push each row of the indicated range to record in your spreadhseet separately, but not within one same cell.
    Compare:
    Screenshot by Lightshot / Screenshot by Lightshot and Screenshot by Lightshot / Screenshot by Lightshot

As an additional example, please see this:

We will update our plugin documentation for sure, but it can take some time. When it will be ready - I inform you. Thank you for pointing out our attention to that.

Hope it helps.
:pray:

1 Like
#7

Thank you @kate

Appreciate your input on this one. Will check this out and see if it works as expected.

Regards,

1 Like
#8

@kate Thanks for your support!

Finished my workflow with sheet creation works nice. :slight_smile:

Another question how would I use Update action ? How the json should be structured?

Screenshot 2023-02-17 at 18.40.37
Screenshot 2023-02-17 at 18.40.371358×1182 85.6 KB

I have a simple use case. I want to update an existing created Google Sheet with new values from database if there is new data.

Let’s say we have a questionnaire with 3 user who are replying, and one user had responded the questions with respective answers that I’m saving to db in a table and this table I am sending to Google Sheets by using your plugin and creating a sheet with data from table.

Next I want to trigger the Update action when new data is save in data table from the second user, and then from the 3rd.

How can I do that using this action?
Can I send it via backend wf and trigger it on front end?

Would really appreciate this help as it is important for user flow.

Thanks.

#9

Hello @kate

Could you kindly reply to my query? Or at least answer that my ticket is still on track?
Would really appreciate some clear communication here.

Thanks,
James.

#10

Hello, @James.JJ.

Sure thing. I have passed your request to the plugin developer team. I will get back to you as soon as there is any feedback.

Thank you for your patience :slightly_smiling_face:

#11

@James.JJ, thank you for your patience.

Unfortunately, the “Update a Spreadsheet” action can’t be used for exporting data from the Bubble database to the Google Sheet. It will be better to use the same “Add column” action.

I don’t know exactly your use case, but you may need to use scheduled workflows (for recurring auto-update the spreadsheet). Please note that this might slow down your page performance a bit, thus, it may be better to use the button triggered spreadsheet update logic.

Hope it helps :slightly_smiling_face:

1 Like