I want Zapier to monitor a file in a Google Drive and pass changed data to GPT4 as a prompt to complete. I want to store the generated completion in the file. Is that possible either A) within a “custom” GPTs (i.e. the 6 November OpenAI GPTs product) or B) by directly connecting Zapier via the OpenAI API?
For example:
Step 1: Zapier should monitor a Google Sheet for changes to the 2nd row.
Step 2. When Zapier detects a change to the 2nd row it should pass the new contents of the 2nd row to GPT4 to use as a chat prompt.
Step 3. GPT4 should process that chat prompt and return a completion to Zapier.
Step 4. Zapier should replace the 3rd row of that Google Sheet with the completion.
If it’s not possible for Google Drive is it possible for any other cloud providers?
Thanks.