Google Sheets + SwiftFox

Google Sheets + SwiftFox integrations

Update SwiftFox persons when new or updated rows appear in Google Sheets

Keep your SwiftFox contact information current with this workflow. Once implemented, it ensures that any changes or additions to your Google Sheets data are immediately reflected in your SwiftFox database. By linking these two applications, this flow promises meticulous data management and time-saving efficiencies. It offers a straightforward solution to maintaining up-to-date contact details in your company's database.

When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Update PersonUpdates a Person in SwiftFox
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Sheets and SwiftFox

Discover other triggers and actions you can use with Google Sheets and SwiftFox

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
New Email Added
Triggers when a new email address is added to a Person or Organisation.
Trigger
Instant
Try It
New Person
Triggers when a new person is created in SwiftFox.
Trigger
Polling
Try It
Removed Contact Detail
Triggers when a contact detail is removed from a Person or Organisation in SwiftFox.
Trigger
Instant
Try It
Updated Category Type on a Person
Triggers when Category Types change on a Person.
Trigger
Instant
Try It
Updated Custom Field
Triggers when a custom field is created or updated on a Person, Organisation or Project in SwiftFox.
Trigger
Instant
Try It
- Record Type
  Required
- Record Id
  Required
- Address Type
  Required
- Address 1
  Required
- Locality/Suburb
  Required
- State
  Required
- Post Code
  Required
- Country (ISO Code - 2 letters)
  Required
Action
Write
- Contact ID
  Required
- Contact Type
  Required
- Table ID
  Required
- Row Data
  Required
Action
Write
- First Name
  Required
- Last Name
  Required
- Email
- Mobile
- Phone
- Date of Birth
- Prevent Duplicate Contacts
Action
Write
- Contact ID
  Required
- Contact Type
  Required
- Effective Date
  Required
- Currency
  Required
- Payment Method
  Required
- Provider
  Required
- Transaction Reference
- Receipt Number
- Amount in cents
  Required
- Description
Action
Write
- Person Id
  Required
- First Name
- Lastname
- Title
- Other Names
- Suffix
- Known As
- Date of Birth
- Place of Birth
- School Attended
- University Attended
- Occupation
- Category Type
Action
Write
- Contact ID
  Required
- Contact Type
  Required
- Table ID
  Required
- Page Number
- Page Size
Action
Search
- ID
  Required
Action
Search
- Contact ID
  Required
- Contact Type
  Required
Action
Search
- First Name
- Last Name
- Email
- Mobile
- Category Types
Action
Search
- Name
  Required
- Category Type
- Known As Name
Action
Search or write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
New Organisation
Triggers when a new Organisation is created in SwiftFox.
Trigger
Polling
Try It
New Form Response
Triggers when a new form response is submitted.
Trigger
Instant
Try It
Updated Category Type on an Organisation
Triggers when Category Types change on an Organisation.
Trigger
Instant
Try It
Updated Contact Detail
Triggers when a contact detail is updated on a Person or Organisation in SwiftFox.
Trigger
Instant
Try It
Updated Email Preferences
Triggers when email preferences are updated on an Email Address.
Trigger
Instant
Try It
- Record Type
  Required
- Record Id
  Required
- Contact Type
  Required
- Contact Value
  Required
Action
Write
- Name
  Required
- Known As Name
Action
Write
- Record Type
  Required
- Record Id
  Required
- Content
  Required
- Date
  Required
Action
Write
- Contact ID
  Required
- Contact Type
  Required
- Table ID
  Required
- Row ID
  Required
- Row Data
  Required
Action
Write
- Contact Type
  Required
Action
Search
- ID
  Required
Action
Search
- Receipt ID
  Required
Action
Search
- Name
- Category Type
Action
Search
- Page Number
  Required
- Date From
  Required
- Date To
- Search Term
Action
Search
- First Name
  Required
- Last Name
  Required
- Email
- Mobile
- Category Types
- Phone
- Date of Birth
- Prevent Duplicate Contacts
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About SwiftFox

SwiftFox is a fully-featured cloud-based Customer Relationship Management (CRM) platform with everything you need to compete.

HelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier