• Google Sheets logoGoogle Sheets logo
  • Onfleet logoOnfleet logo

Google Sheets + Onfleet

Create tasks in Onfleet from new rows on Google Sheets

If you've already got all your action items on a spreadsheet, there's no need to copy them over to your delivery platform manually. This integration will handle all of it after you set it up. From then on, it will capture the information you add to a new row on Google Sheets, automatically creating a matching task on Onfleet for each one.

If you've already got all your action items on a spreadsheet, there's no need to copy them over to your delivery platform manually. This integration will handle all of it after you set it up. From then on, it will capture the information you add to a new row on Google Sheets, automatically creating a matching task on Onfleet for each one.

  1. When this happens...
    Google SheetsGoogle Sheets
    New or Updated Spreadsheet Row

    Triggered when a new row is added or modified in a spreadsheet.

    TriggerInstant
  2. automatically do this!
    OnfleetOnfleet
    Create Task

    Creates a pickup or dropoff task.

    ActionWrite
  • Google Sheets triggers, actions, and search
    New Spreadsheet Row (Team Drive)
    Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    New Spreadsheet Row
    Triggered when a new row is added to the bottom of a spreadsheet.
    Trigger
    Instant
  • Google Sheets triggers, actions, and search
    New Spreadsheet
    Triggered when you create a new spreadsheet.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    New or Updated Spreadsheet Row (Team Drive)
    Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    New or Updated Spreadsheet Row
    Triggered when a new row is added or modified in a spreadsheet.
    Trigger
    Instant
  • Google Sheets triggers, actions, and search
    New Worksheet
    Triggered when you create a new worksheet in a spreadsheet.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    Create Spreadsheet Column
    Create a new column in a specific spreadsheet.
    Action
    Write
  • Google Sheets triggers, actions, and search
    Create Spreadsheet Row
    Create a new row in a specific spreadsheet.
    Action
    Write
  • Google Sheets

    Create one or more new rows in a specific spreadsheet (with line item support).

    Scheduled

    Action

  • Google Sheets

    Create a new worksheet by copying an existing worksheet.

    Scheduled

    Action

  • Google Sheets

    Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.

    Scheduled

    Action

  • Google Sheets

    Create a blank worksheet with a title. Optionally, provide headers.

    Scheduled

    Action

  • Google Sheets

    Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

    Scheduled

    Action

  • Google Sheets

    Update a row in a specific spreadsheet.

    Scheduled

    Action

  • Google Sheets

    Finds many matched rows (10 max.) by a column and value.

    Scheduled

    Action

  • Google Sheets

    Returns many rows (20 max.) as a single JSON value and flat rows (line items).

    Scheduled

    Action

  • Google Sheets

    Finds a row by a column and value. Returns the entire row if one is found.

    Scheduled

    Action

  • Google Sheets

    Finds or creates a specific lookup row.

    Scheduled

    Action

  • Onfleet

    Triggers when an Onfleet recipient responds to a notification via SMS, but the organization is unable to handle it due to the task being marked as complete.

    Instant

    Trigger

  • Onfleet

    Triggers when a driver is arriving, at or closer than threshold value provided, in meters.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is assigned to a driver or a team.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is cloned via the dashboard or the API. Note that the TaskCreated trigger will not fire when a task is simply cloned.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is completed by a driver.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is created.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task has a delay time greater than or equal to a user-defined threshold, in seconds.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is deleted.

    Instant

    Trigger

  • Onfleet

    Triggers when the Onfleet task ETA is less than or equal to a user-defined threshold.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is completed with a failure.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is started.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is unassigned from a driver or a team.

    Instant

    Trigger

  • Onfleet

    Triggers when an Onfleet task is updated, including assignment, feedback, and attachment (photo, signature) changes.

    Instant

    Trigger

  • Onfleet

    Triggers when a driver (worker) changes status (0 for off-duty, 1 for on-duty).

    Instant

    Trigger

  • Onfleet

    Creates a pickup or dropoff task.

    Scheduled

    Action

  • Onfleet

    Creates a linked pickup and dropoff task.

    Scheduled

    Action

  • Onfleet

    Creates a single task. Used for simple zap templates only.

    Scheduled

    Action

google-sheets logo
google-sheets logo

About Google Sheets

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

Related categories

Similar apps

Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
Quip integrations

Quip

Documents
onfleet logo
onfleet logo

About Onfleet

Onfleet transforms cumbersome last-mile logistics into delightful delivery management. Intuitive smartphone apps, powerful web dashboard and automatic customer notifications handle the heavy lifting so you can focus on your customer.
Learn more

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

Or
By signing up, you agree to Zapier’s Terms of Service and Privacy Policy