My Goal: To auto translate text in Google Sheets from Google Docs
How I want the ZAP to work:
Is this possible?
Best answer by Anonymous
View originalHey! Sorry - As Steph explained, my account is being restored.
The Airtable solution would just be to have a database of all your docs, and when one is updated, you could check a box, and automatically trigger your script to run. It is basically the same as the first solution though - Just, in my eyes a bit cleaner and easier to manage.
+9
Hello! For the first part, you should just be able to do this with a simple Google Docs (New Document) to Google Sheets zap (New Row). You’ll likely need to strip the HTML tags before sending it to G-Sheets.
For the second part...You’ll need to have a way to manage this, and you could do it in any number of ways.
If you can update the doc and put it in a new folder to trigger a zap you could:
Hope this helps. How easy this will be will be dependent on your reliance of Google tools. I think you could perhaps manage this better by using something like Airtable.
Let us know how you get on!
Thanks. Can I make your solution work with two folders or is a new folder needed for every change?
What would the AirTable solution be?
+8
Hi there
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
