Inserting function in Google Sheets - possible?

Hi! I am trying to scrape text and make this a variable in a Google Sheets function. So:

scrape website text → use merge to insert scraped text into function → add as row to google sheets.

This is the merge function I am using:

And this is the result.

image

As you see, it keeps adding a ’ (apostrophe) before the function that i created with Merge. This results in the function not working. Can I fix this somehow?

Hi Bob,

Bardeen treats symbols like ‘+’, ‘=’, and ‘.’ as plain text in Google Sheets, preventing errors and ensuring data like phone numbers are processed correctly. You don’t need to send formulas through Bardeen; just add your data and then manually insert the necessary formulas directly in Sheets after the data is uploaded.

Hope this helps!
Lucy

Customer Support - bardeen.ai
Explore | @bardeenai | Bardeen Community

Thanksfor the support Bardeeni? Is there perhaps a substitute or replace function in bardeen? I want to limit manual work as much as possible.

Hi there,

I have similar issue as Bob. I want to manipulate different kind of texts before handing them over from one Bardeen action to another (split, trim, replace, ect…) Now the easiest way would be to map these data into a Gsheet table, write cell functions_within_the table, and then use these manipulated texts in the further steps.

Now the thing is: Bardeen treats Gsheet functions as texts, so it doesn’t work.

And when I try to insert these functions as a new text/value in my Bardeen “add/update new row” module, it just does not work. It disappears after editing. I can transfer mapped data from previous tasks but not strings. Or did I miss something?

I also tried “Use a command line to specify a value” option instead of mapping and pure strings, but I don’t know what kind of format/structure Bardeen asks for…

Could you please help me out with this?

Thank you
Janos

1 Like

Hi @Bob we don’t have “Substitute” or “Replace” text actions. You can add an OpenAI action to the automation
which might be able to do that, but it would be a premium action.

Thanks,
Lucy

1 Like

Hi @janos.bencsik. Happy to help further with this if you can send the Google Sheet with edit access to lucy@bardeen.ai.

Thanks,
Lucy

1 Like

HI Lucy,
Thanks for the response. It looks like it is not just me who misses the native options to manipulate text in Bardeen. see also the response from @janos.bencsik. Perhaps consider putting this on the roadmap? In any event, thank you for the support.
–Bob

For sure! I was just talking to the product team about this. We will let you know when that is scoped and added to the roadmap :slightly_smiling_face:

Cheers,
Lucy

Customer Support - bardeen.ai
Explore | @bardeenai | Bardeen Community

1 Like

Hi Lucy, thank you very much, I shared it with you and sent you some basic info via an e-mail.

Cheers,
Janos