PostgreSQL + Google Sheets + Tapfiliate Integrations
How to connect PostgreSQL + Google Sheets + Tapfiliate
Zapier lets you send info between PostgreSQL, Google Sheets, and Tapfiliate automatically—no code required.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with PostgreSQL + Google Sheets + Tapfiliate
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with PostgreSQL, Google Sheets, and Tapfiliate. And don’t forget that you can add more apps and actions to create complex workflows.
QueryRequired
Query results must have a unique
idfield so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTable/ViewRequired
Primary KeyRequired
Usually something auto-incremented like
id. Must be unique. Column names that contain a space must be enclosed within brackets[ ].Order ByRequired
Usually something like
date_updatedorlast_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.Trigger Column
Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ID ColumnRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.QueryRequired
You should include desired ordering and limiting (usually to 1 record) in the query.
This query must run in less than ~30 seconds.
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Affiliate
Triggers when a new affiliate is created (i.e. signed up or was added by you).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Affiliate Prospect Promoted
Triggers when a new affiliate prospect is promoted to affiliate (i.e. created a Conversion or Customer).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ConversionRequired
Sub Amount
The amount on which the Commission should be calculated using the supplied commission type or the program's default commission type.
Commission Type
The identifier of the Commission Type for this commission.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Coupon
The affiliate's unique coupon code. You can create coupons for your affiliates on their profile page.
Referral Code
The affiliate's referral code.
Click ID
Instead of a coupon code, you can use a Click ID to create a conversion. A Click ID is usually obtained by including the ${click.id} merge tag in your landing page url, when using the "redirect" tracking mode. Unless your integration guide recommends you to use it, you will probably not need this field.
Customer IDRequired
Your unique ID for this customer. This can for instance be your payment gateway's customer id (like the Stripe customer ID) or the ID you have for the customer in your own database.
Initial StatusRequired
The initial status for this Customer.
Meta Data
You can send along extra data in this field. This can be anything you like and will be shown alongside the conversion.
Ignore Max Cookie Time
When set to true, your program's cookie time setting will be ignored for this conversion, i.e. a Conversion will be tracked regardless of whether or not the preceding click was within the allowed number of days.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Child AffiliateRequired
Parent AffiliateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
The ID of the Customer to update. This is not the Customer ID you passed when creating the customer, but rather the Tapfiliate generated ID. The ID is usually obtained through the "Find Customer" search.
ActionRequired
Whether to Cancel or to Uncancel the Customer. If the Customer is Uncanceled, the Customer status will jump back to the appropriate status, e.g "Active" or "Capped".
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProgramRequired
The program of which the affiliate is a member.
Affiliate EmailRequired
The affiliate's email.
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal IDRequired
The External ID of the Conversion to be found. This is usually an order ID or user ID, depending on your chosen integration. This field has to match the External ID of the conversion exactly. You can see the External ID of your Conversions on the Conversions & Commissions page in the Tapfiliate dashboard.
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
The affiliate's email.
Affiliate ID
The affiliate's ID.
Last NameRequired
First NameRequired
Password
An optional password. If no password is provided, Tapfiliate will automatically generate a password and email it to your affiliate.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProgramRequired
The program of which the affiliate is a member.
Affiliate EmailRequired
The affiliate's email.
Affiliate IdRequired
Approved
Coupon
An optional coupon code for this affiliate in this program.
Send Welcome Email
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal ID
Your unique ID for this conversion. This can for instance be an order ID or a user ID.
Customer ID
The ID of the Customer making the purchase. If you have recurring / lifetime commissions enabled in your program settings, and a Customer exists for this ID, the conversion will be attributed to the original referring affiliate of the customer. If no customer exists, it will be automatically created.
Referral Code
The affiliate's referral code.
Coupon
The affiliate's unique coupon code. You can create coupons for your affiliates on their profile page.
Click ID
Instead of a coupon code, you can use a Click ID to create a conversion. A Click ID is usually obtained by including the ${click.id} merge tag in your landing page url, when using the "redirect" tracking mode. Unless your integration guide recommends you to use it, you will probably not need this field.
Amount
The amount for the conversion.
Commission Type
The identifier of the Commission Type for this Conversion.
Meta Data
You can send along extra data in this field. This can be anything you like and will be shown alongside the conversion.
Ignore Max Cookie Time
When set to true, your program's cookie time setting will be ignored for this conversion, i.e. a Conversion will be tracked regardless of whether or not the preceding click was within the allowed number of days.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCustomer IDRequired
Your unique ID for this customer. This can for instance be your payment gateway's customer id (like the Stripe customer ID) or the ID you have for the customer in your own database.
Coupon
The affiliate's unique coupon code. You can create coupons for your affiliates on their profile page.
Referral Code
The affiliate's referral code.
Click ID
Instead of a coupon code, you can use a Click ID to create a conversion. A Click ID is usually obtained by including the ${click.id} merge tag in your landing page url, when using the "redirect" tracking mode. Unless your integration guide recommends you to use it, you will probably not need this field.
Initial StatusRequired
The initial status for this Customer.
Meta Data
You can send along extra data in this field. This can be anything you like and will be shown alongside the conversion.
Ignore Max Cookie Time
When set to true, your program's cookie time setting will be ignored for this conversion, i.e. a Conversion will be tracked regardless of whether or not the preceding click was within the allowed number of days.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Table/ViewRequired
We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
Order By
Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like
date_createdor your autoincrementid. Column names that contain a space must be enclosed within brackets[ ].Dedupe Key
We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Table
Triggered when you add a new table.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TableRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Affiliate Prospect
Triggers when a new affiliate prospect is created (i.e. signed up or was added by you).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Conversion
Triggers when a new conversion is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Payment
Triggers when a new affiliate payment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer ID
The ID of the Customer making the purchase. If you have recurring / lifetime commissions enabled in your program settings, and a Customer exists for this ID, the conversion will be attributed to the original referring affiliate of the customer. If no customer exists, it will be automatically created.
Referral Code
The affiliate's referral code.
Coupon
The affiliate's unique coupon code. You can create coupons for your affiliates on their profile page.
Click ID
Instead of a coupon code, you can use a Click ID to create a conversion. A Click ID is usually obtained by including the ${click.id} merge tag in your landing page url, when using the "redirect" tracking mode. Unless your integration guide recommends you to use it, you will probably not need this field.
Amount
The amount for the conversion.
Commission Type
The identifier of the Commission Type for this Conversion.
External ID
Your unique ID for this conversion. This can for instance be an order ID or a user ID.
Meta Data
You can send along extra data in this field. This can be anything you like and will be shown alongside the conversion.
Ignore Max Cookie Time
When set to true, your program's cookie time setting will be ignored for this conversion, i.e. a Conversion will be tracked regardless of whether or not the preceding click was within the allowed number of days.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.GroupRequired
AffiliateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Commission IDRequired
The ID of the Commission to update. The Commission ID is usually obtained through the "Find Conversion" search.
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
The affiliate's email.
Affiliate ID
The affiliate's ID.
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail
The affiliate prospect's email.
Affiliate Prospect ID
The affiliate prospect's ID.
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer IDRequired
The Customer ID of the Customer to be found.
ActionThis is an event a Zap performs.SearchFind existing data in your appProgramRequired
Affiliate EmailRequired
The affiliate's email.
Affiliate IdRequired
Approved
Coupon
An optional coupon code for this affiliate in this program.
Send Welcome Email
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEmailRequired
The affiliate prospect's email.
Affiliate Prospect ID
The affiliate prospect's ID.
Last NameRequired
First NameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal IDRequired
Your unique ID for this conversion. This can for instance be an order ID or a user ID.
Customer ID
The ID of the Customer making the purchase. If you have recurring / lifetime commissions enabled in your program settings, and a Customer exists for this ID, the conversion will be attributed to the original referring affiliate of the customer. If no customer exists, it will be automatically created.
Referral Code
The affiliate's referral code.
Coupon
The affiliate's unique coupon code. You can create coupons for your affiliates on their profile page.
Click ID
Instead of a coupon code, you can use a Click ID to create a conversion. A Click ID is usually obtained by including the ${click.id} merge tag in your landing page url, when using the "redirect" tracking mode. Unless your integration guide recommends you to use it, you will probably not need this field.
Amount
The amount for the conversion.
Commission Type
The identifier of the Commission Type for this Conversion.
Meta Data
You can send along extra data in this field. This can be anything you like and will be shown alongside the conversion.
Ignore Max Cookie Time
When set to true, your program's cookie time setting will be ignored for this conversion, i.e. a Conversion will be tracked regardless of whether or not the preceding click was within the allowed number of days.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How PostgreSQL + Google Sheets + Tapfiliate Integrations Work
- Step 1: Authenticate PostgreSQL, Google Sheets, and Tapfiliate.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About PostgreSQL
Related categories
Similar apps
MySQL
Databases
SQL Server
Databases
Amazon Relational Database Services (RDS)
Amazon, Databases
About Google Sheets
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
About Tapfiliate
Related categories
Similar apps
Shopify
eCommerce
Keap Max Classic
Marketing Automation
SendOwl
eCommerceGet started for free
You can't add more hours to the day. Zapier is the next best thing.
Other PostgreSQL + Google Sheets Integrations
- hubspot
- twilio
- zendesk
- mailchimp
- intercom
- mailjet
- typeform
- zapier-chrome-extension
- sendgrid
- looping
- front-app
- clickup
- asana
- airtable
- basecamp3
- salesforce
- mandrill
- activecampaign
- wpforms
- stripe
- simpletix
- scheduleonce
- pushbullet
- process-street
- plivo
- phantombuster
- mysql
- mailgun
- linear
- klaviyo
- kickofflabs
- google-forms
- digest
- customerio
- bank-mercury
- acuity-scheduling
- formstack
- swit
- storage
- pipefy
- facebook-lead-ads