Email Automation

gmail-attachment-organizer/
  config.ts
  version.json
  project.json
  workflows/
    gmail-attachment-processor.json

{
  triggerId: crypto.randomUUID(),
  type: 'service_event' as const,
  service: 'email' as const,
  eventType: 'new_email_with_attachment',
  title: 'New Email with Attachment',
  description: 'Triggers when a new email with one or more attachments arrives',
}

export function getDeploymentInputSchema(): DeploymentInputSchema {
  return [
    {
      key: 'DRIVE_FOLDER_NAME',
      type: 'string',
      label: 'Drive Folder Name',
      description: 'Name of the Google Drive folder to save attachments to',
      placeholder: 'Email Attachments',
      required: true,
      defaultValue: 'Email Attachments',
    },
    {
      key: 'GMAIL_LABEL_NAME',
      type: 'string',
      label: 'Gmail Label',
      description: 'Label to apply to processed emails',
      placeholder: 'Processed',
      required: true,
      defaultValue: 'Processed',
    },
    {
      key: 'SHEET_NAME',
      type: 'string',
      label: 'Spreadsheet Name',
      description: 'Name of the Google Sheet to log attachment metadata',
      placeholder: 'Attachment Log',
      required: true,
      defaultValue: 'Attachment Log',
    },
  ];
}

integrationUids: ['google_gmail', 'google_drive', 'google_sheets'],

function getOutputSchema(): FormOutputSchema {
  return [
    {
      key: 'files_saved',
      type: 'number',
      label: 'Files Saved',
      numberType: 'integer',
    },
    {
      key: 'sender',
      type: 'string',
      label: 'Sender Email',
    },
    {
      key: 'drive_folder_id',
      type: 'string',
      label: 'Drive Folder ID',
    },
    {
      key: 'spreadsheet_id',
      type: 'string',
      label: 'Spreadsheet ID',
    },
  ];
}

Gmail Trigger (polling) → Codika Init (API mode) → Get Attachments → Save to Drive → Log to Sheet
                                                    → IF Success → Submit Result
                                                    → IF Error   → Report Error

{
  "parameters": {
    "resource": "processManagement",
    "operation": "initWorkflow",
    "memberSecret": "{{MEMSECRT_EXECUTION_AUTH_TRCESMEM}}",
    "organizationId": "{{USERDATA_ORGANIZATION_ID_ATADRESU}}",
    "userId": "{{USERDATA_USER_ID_ATADRESU}}",
    "processInstanceId": "{{USERDATA_PROCESS_INSTANCE_UID_ATADRESU}}",
    "workflowId": "gmail-attachment-processor",
    "triggerType": "gmail"
  }
}

const folderName = {{INSTPARM_DRIVE_FOLDER_NAME_MRAPTSNI}};
const labelName = {{INSTPARM_GMAIL_LABEL_NAME_MRAPTSNI}};
const sheetName = {{INSTPARM_SHEET_NAME_MRAPTSNI}};

"credentials": {
  "gmailOAuth2": {
    "id": "{{USERCRED_GOOGLE_GMAIL_ID_DERCRESU}}",
    "name": "{{USERCRED_GOOGLE_GMAIL_NAME_DERCRESU}}"
  }
}