My Google Sheets & Charts Service typically works very well when I send data from my Bubble database to a Google sheet.

However, if that data contains a double quote (") it creates an error. I believe this is because the format for sending data to Google sheets using the Zeroqode plug in requires quotes to be around the data, such as [“data”].

What I have tried to do is to find any double quotes (") from items in my database and replace them with a single quote (’). For example, as shown in the screen shot below, I would like to replace “Batman” and “Hulk” in the first and third Topic fields to instead be ‘Batman’ and ‘Hulk’ . If the double quotes are replaced by the single quote, there will be no error when using the ZQ plugin to send date to Google Sheets.

I have tried workflows Make changes to a thing and Make changes to a list of things , and also the Find & Replace operation, but I can’t get it to work.

So, if you’d like to retrieve the data from your Bubble database, which includes records with double quotes, you could save your db data into a state, then modify the value of this state accordingly, and send this value to your Google Sheets.

Also, if you like our plugin so far, could you please rate it by going to Plugins tab in Bubble editor. You can find the plugin by name and give it as many stars as it deserves. The more feedback we get, the more motivated we are to build great plugins!