Automate VC Data Flow: Salesforce for Diligence

{
  "name": "Salesforce VC Data Sync",
  "version": 1,
  "description": "Automates the creation/update of Salesforce Accounts and Contacts from a Google Sheet.",
  "triggers": [
    {
      "module": "Google Sheets",
      "action": "watchNewOrUpdatedRows",
      "parameters": {
        "spreadsheetId": "YOUR_SPREADSHEET_ID",
        "sheetName": "Investors",
        "column": "A",
        "limit": 100,
        "since": null,
        "filter": null,
        "order": "asc",
        "fields": []
      },
      "id": 1
    }
  ],
  "actions": [
    {
      "module": "Salesforce",
      "action": "findRecords",
      "parameters": {
        "object": "Account",
        "filter": {
          "field": "Name",
          "operator": "equal",
          "value": "{{1.CompanyName}}"
        },
        "limit": 1
      },
      "id": 2
    },
    {
      "module": "Salesforce",
      "action": "createRecord",
      "parameters": {
        "object": "Account",
        "fields": {
          "Name": "{{1.CompanyName}}",
          "Industry": "{{1.Industry}}"
        }
      },
      "id": 3,
      "condition": {
        "module": 2,
        "operator": "equal",
        "value": 0
      }
    },
    {
      "module": "Salesforce",
      "action": "findRecords",
      "parameters": {
        "object": "Contact",
        "filter": {
          "field": "Email",
          "operator": "equal",
          "value": "{{1.InvestorEmail}}"
        },
        "limit": 1
      },
      "id": 4
    },
    {
      "module": "Salesforce",
      "action": "createRecord",
      "parameters": {
        "object": "Contact",
        "fields": {
          "FirstName": "{{1.InvestorFirstName}}",
          "LastName": "{{1.InvestorLastName}}",
          "Email": "{{1.InvestorEmail}}",
          "AccountId": "{{2.id}}" 
        }
      },
      "id": 5,
      "condition": {
        "module": 4,
        "operator": "equal",
        "value": 0
      }
    },
    {
      "module": "Salesforce",
      "action": "updateRecord",
      "parameters": {
        "object": "Account",
        "id": "{{2.id}}",
        "fields": {
          "Industry": "{{1.Industry}}"
        }
      },
      "id": 6,
      "condition": {
        "module": 2,
        "operator": "equal",
        "value": 1
      }
    },
    {
      "module": "Salesforce",
      "action": "updateRecord",
      "parameters": {
        "object": "Contact",
        "id": "{{4.id}}",
        "fields": {
          "FirstName": "{{1.InvestorFirstName}}",
          "LastName": "{{1.InvestorLastName}}",
          "AccountId": "{{2.id}}" 
        }
      },
      "id": 7,
      "condition": {
        "module": 4,
        "operator": "equal",
        "value": 1
      }
    }
  ],
  "connections": [
    {"from": 1, "to": 2, "label": "CompanyName"},
    {"from": 1, "to": 4, "label": "InvestorEmail"},
    {"from": 2, "to": 3, "label": "Account Not Found"},
    {"from": 2, "to": 6, "label": "Account Found"},
    {"from": 4, "to": 5, "label": "Contact Not Found"},
    {"from": 4, "to": 7, "label": "Contact Found"},
    {"from": 3, "to": 5, "label": "Create Contact for New Account"},
    {"from": 6, "to": 7, "label": "Update Contact for Existing Account"}
  ]
}