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:

1. New Doc in folder (updated text)
2. Look up doc ID in G-Sheets (Will need to have been added previously)
3. Update text
4. Put Doc back in main folder

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? 

Hi there @Dante - Thanks for being patient. Andy’s account is currently being restored so he’s not able to respond directly to you. I’ve alerted him to best give you an answer and I’ll be sure to come back with it. Thanks again and stay tuned!

Hey! Sorry - As Steph explained, my account is being restored.

1. Yes - The solution should work with two folders - You can use the “New file in folder” trigger

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.