Hi guys,

I have the following workflow that I want to create with Zapier:

1. Zapier Tables: If I add a new row to Zapier sheet “ABC”, then send the data to a Formatter.

Please note: There is a row called “JSON” and there we store links of Google Docs files that have been uploaded to a Google drive folder.

2. Google Docs: As already mentioned, we create new Google Docs and the link is being stored in row “JSON” in Zapier Tables.
3. Formatter + Claude AI: Now we want to combine the data from Zapier Table AND Google Docs and create send the combined data to Claude AI to create a text out of it. 
4. Claude AI + Google Docs: Output text should be stored in a new Google Docs.

For a better understand, let me summarize the workflow again in different words: 

We have 2 data sources (Zapier Tables and Google Docs sheet) and want to combine the information from both files as the data from Google Docs is too big to store it in a Zapier table cell.

The combined data should be sent to Claude AI to create a text and store it in a newly created Google Docs.

Questions:

1. How can I combine data from different sources? How does the worklow look like?
2. What are the steps that I need to take to create the workflow?

Many thanks in advance for your help!

Best regards

Jon