Connect Google BigQuery and PostStack

Both apps 52Google BigQuery 14PostStack 38

• Trigger
  New Job Completed

  Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

• Trigger
  New Row

  Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

• Trigger
  Query Job Completed (With Row Data)

  Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

• Trigger
  Updated Row

  Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

• Action
  Create Row

  Creates a new row of data in a table. Note: Does not create a job.

• Action
  Create Rows

  Creates new rows of data in a table (accepts line items). Note: Does not create a job.

• Action
  Delete Rows

  Deletes every row in a table whose match column equals the value you give.

• Action
  Find One Row

  Finds the first row in a table whose column equals the value you give.

• Action
  Get Rows for Job Completed

  Returns the result rows of a finished query job.

• Action
  Import Data

  Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

• Action
  List Datasets

  Returns the datasets in a Google Cloud project.

• Action
  List Tables

  Returns the tables in a BigQuery dataset.

• Action
  Run a Query

  Runs a SQL query against a table in BigQuery.

• Action
  Update Row(s)

  Updates every row in a table whose match column equals the value you give, setting the columns you choose.

• Trigger
  Contact Deleted (instant)

  Fires when a contact is deleted (event: contact.deleted).

• Trigger
  Contact Updated (instant)

  Fires when a contact is updated (event: contact.updated).

• Trigger
  Email Bounced (instant)

  Fires when an email bounces (event: email.bounced).

• Trigger
  Email Delivered (instant)

  Fires when an email is delivered (event: email.delivered).

• Trigger
  New Contact (instant)

  Fires when a contact is created (event: contact.created).

• Trigger
  New Inbound Email

  Polls for newly received inbound emails.

• Trigger
  New Sent Email (instant)

  Fires when an email is sent (event: email.sent).

• Action
  Add a broadcast

  Create a new marketing broadcast.

• Action
  Add a contact

  Create a new contact.

• Action
  Add a segment

  Create a new manual contact segment.

• Action
  Add a template

  Create a new email template.

• Action
  Add contacts to segment

  Add contacts to an existing segment.

• Action
  Add suppression

  Add an address to the suppression list.

• Action
  Cancel broadcast

  Cancel an in-flight broadcast.

• Action
  Cancel email

  Cancel a scheduled or queued email before it sends.

• Action
  Delete a contact

  Delete a contact.

• Action
  Delete a template

  Delete an email template.

• Action
  Get a contact

  Fetch one contact by ID.

• Action
  Get a template

  Fetch one email template by ID.

• Action
  Get broadcast

  Retrieve one broadcast by its public id, including the HTML and text bodies that the list endpoint omits.

• Action
  Get email

  Fetch one sent or queued email by ID.

• Action
  Get email events

  Get the delivery event timeline for one email.

• Action
  Get inbound email

  Fetch one received inbound email by ID.

• Action
  Import contacts

  Bulk-import a CSV list of contacts.

• Action
  List broadcasts

  List marketing broadcasts.

• Action
  List contacts

  List contacts in the account.

• Action
  List emails

  List sent, queued, and scheduled emails.

• Action
  List inbound emails

  List emails received via inbound parsing.

• Action
  List segments

  List contact segments.

• Action
  List suppressed addresses

  List addresses on the suppression list.

• Action
  List templates

  List email templates.

• Action
  Send an email

  Send a transactional email through PostStack.

• Action
  Send broadcast

  Start sending a broadcast to its recipients.

• Action
  Send emails in batch

  Send up to 100 emails in a single request.

• Action
  Update a contact

  Update an existing contact's fields.

• Action
  Update a template

  Update an email template, creating a new version.

• Action
  Update email

  Reschedule a queued email's send time.

• Action
  Validate email address

  Check whether an email address is valid and deliverable.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.