Hello. I have created a translating automation using a sheet. Now that I have the translations, I have to update them back to our e-commerce platform (PrestaShop). I am playing around with sheets to see the outputs before I upload anything to our online store and I can’t seem to figure out how to determine a specific cell and get data from it. I am using get range values because I don’t want to make a separate action for all 16 languages for 3 different translated segments. I see that getting range values works well when collecting my data; however, I can’t just select the cells F6 and E5 and paste their values to a given place. This is my current argument.
Hey there,
the get() formula works on arrays of data. What you have mapped there isn’t an array.
Can you show a screenshot of what the incoming data looks like and highlight which part you want to extract from it?