Inserting function in Google Sheets - possible?

🏁 Getting started.
1

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:

image
image1372×808 60.1 KB

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?

1 Like
2

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

1 Like
3

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

1 Like
4

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

2 Likes
5

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
6

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
7

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

1 Like
8

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

2 Likes
9

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

Cheers,
Janos

10

Please add a way to disable this safety feature.
Being able to add functions directly to cells would be incredibly powerful!
I’m scraping products and rather than just getting image urls, adding “=IMAGE(INDIRECT(“Sheet1!C”&ROW()))” would make the images appear on each row.
This would not only be immensely pleasing, but would also allow us to fully automate further steps.
One could even use “=GOOGLETRANSLATE(INDIRECT(“Sheet1!B”&ROW()), “FR”, “EN”)” for example, to translate data in real time without spending gpt tokens

1 Like