Archive signed Adobe Sign contracts to Google Drive and log them in Sheets

Whenever an Adobe Acrobat Sign agreement is fully completed, archive the signed PDF to a dated Google Drive folder and append a tracking row to our contracts spreadsheet in Google Sheets. The whole pipeline is deterministic — each step's inputs come from the previous step, there is no reasoning or drafting.

Trigger: an Adobe Acrobat Sign outgoing webhook that fires when an agreement transitions to COMPLETED. The webhook payload gives us the agreement id to work with.

Step 1. In Adobe Acrobat Sign, call Get Agreement with the agreement id from the webhook to pull the agreement name, sender, and completion timestamp.

Step 2. In Adobe Acrobat Sign, call Get Agreement Members with the same agreement id to collect the full participant list — every signer's name and email address.

Step 3. In Adobe Acrobat Sign, call Download Combined Document (Signed PDF) with the agreement id to fetch the final signed PDF as binary. This response is raw application/pdf bytes — pass them through to the Google Drive upload as-is, do not try to parse or re-encode them.

Step 4. Derive the archive folder name from the completion timestamp in the format YYYY-MM (for example 2026-07). In Google Drive, look up a folder with that name inside the configured contracts archive parent folder. If it does not exist, call Create Folder to create it first. Cache the folder id for step 5.

Step 5. In Google Drive, call Upload File (Multipart) to upload the PDF from step 3 into the folder from step 4. Use a filename like "<agreement name> - signed.pdf", set the mime type to application/pdf, and capture the returned file id and webViewLink.

Step 6. In Google Sheets, call Append Values on the configured contracts tracking spreadsheet with a single new row containing: agreement name, comma-joined signer names, comma-joined signer emails, completion date (ISO date from the agreement), and the Google Drive webViewLink from step 5.

Configuration the user should provide: the Google Drive parent folder id for the contracts archive, the Google Sheets spreadsheet id, and the sheet/tab name to append to. The column order in the append row should match whatever headers the user already has in that sheet — if not specified, use the order above.

Notes for the build: Download Combined Document returns binary bytes, not JSON — keep it as a Buffer end-to-end. The Adobe Sign base URL is account-specific (apiAccessPoint on the credential), never hardcode a region. Honor Retry-After on 429s. Do not add filtering, formatting, or judgement steps that were not asked for.