Google BigQuery + Roofr

Google BigQuery + Roofr integrations

Create rows in Google BigQuery for new leads created in Roofr

Increase efficiency in dealing with new leads from Roofr by instantly creating data rows in Google BigQuery. This automation ensures every new Roofr lead moves straight into your data analysis, without the need for any manual data entries. It will not only save you time but also lessen the chance of any errors. Enjoy seamless lead management and data tracking with this automated workflow.

When this happens...
Roofr Lead CreatedTriggers when a new lead is submitted via a Roofr Instant Estimator.
TriggerInstant
automatically do this!
Create RowsCreates new rows of data in a table (accepts line items). Note: Does not create a job.
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 Roofr and Google BigQuery

Discover other triggers and actions you can use with Roofr and Google BigQuery

Roofr Lead Created
Triggers when a new lead is submitted via a Roofr Instant Estimator.
Trigger
Instant
Try It
Roofr Report Ordered
Triggers when a Roofr report is ordered from a Job record.
Trigger
Instant
Try It
Proposal Sent
Triggers when a proposal is sent to a client.
Trigger
Instant
Try It
Proposal Total Adjusted
Triggers when a marked as won proposal has its total adjusted.
Trigger
Instant
Try It
- External job id
- External customer id
- Job name
- First_name
  Required
- Last_name
  Required
- Phone
- Email
- Job owner
- Job assignees
- Address
  Required
- City
  Required
- Province/State
  Required
- Zip/Postal Code
  Required
- Country
  Required
Action
Write

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It

- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

Job Workflow Stage Changed
Triggers when a job moves to a different workflow stage.
Trigger
Instant
Try It
Proposal Lost
Triggers when a proposal is moved to lost by a user.
Trigger
Instant
Try It
Proposal Signed
Triggers when a proposal is signed by a client.
Trigger
Instant
Try It
Proposal Viewed
Triggers when a proposal is viewed by a client.
Trigger
Instant
Try It
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

About Roofr

Roofr: spend less time on admin and more time growing your roofing business. Manage reports, proposals, invoicing, payments, and more, on our easy-to-use platform.

Learn moreLearn moreHelpHelp

Related categories

Sales & CRM