EverTransit + Google Sheets

Find EverTransit customers and create rides in EverTransit for new Google Sheets rows

This integration automatically locates a customer and creates a new ride in your EverTransit fleet for each new row in a specified Google Sheets spreadsheet. Manage your ride details directly from your spreadsheet interface.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create Ride
Creates a ride in the fleet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
Driver Created
Triggers when a driver accepts an invitation to a fleet.
Trigger
Instant
Try It
Ride Created
Triggers when a new ride is created.
Trigger
Instant
Try It
Driver Unassigned
Triggers when a driver is unassigned to a ride.
Trigger
Instant
Try It
- EmailRequired
- First nameRequired
- Last nameRequired
- Phone numberRequired
Action
Write
- Pickup addressRequired
- Destination addressRequired
- Service IdRequired
- Schedule timeRequired
- Rider IdRequired
- Passengers
- External Id
- Driver Id
Action
Write
- EmailRequired
- First nameRequired
- Last nameRequired
- Phone numberRequired
Action
Search or write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write

EverTransit + Google Sheets

Find EverTransit customers and create rides in EverTransit for new Google Sheets rows

Supported triggers and actions

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

Driver Created

Ride Created

Driver Unassigned

Create Customer

Create Ride

Find or Create Customer

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet