Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Integrate the Google Sheets API with the FraudLabs Pro API
Setup the Google Sheets API trigger to run a workflow which integrates with the FraudLabs Pro API. Pipedream's integration platform allows you to integrate Google Sheets and FraudLabs Pro remarkably fast. Free for developers.
Popular Ways to Connect Google Sheets with FraudLabs Pro#
Popular Google Sheets and FraudLabs Pro Triggers#
Emit new events each time a row or rows are added to the bottom of a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Row Added (Shared Drive, Instant) source instead.
Emit new events each time a row or rows are added to the bottom of a spreadsheet in a shared drive
Emit new event each time a row or cell is updated in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Updates (Shared Drive, Instant) source instead.
Emit new event each time a row or cell is updated in a spreadsheet in a shared drive
Emit new event each time a new worksheet is created in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Worksheet (Shared Drive, Instant) source instead.
Popular Google Sheets and FraudLabs Pro Actions#
Verify that an OTP sent by the Send SMS Verification API is valid. Please refer to the documentation for the explanation of the result returned.
Send an SMS with verification code and a custom message for authentication purpose. Please refer to the documentation for the explanation of the result returned. NOTE: You need to register for an API key before using this REST API. Please visit Micro Plan to sign up for an API key if you do not have one. In addition, you will also have to make sure you have enough SMS credits to send any verification SMS.
Overview of Google Sheets#
Some examples of things you can build using the Google Sheets API include:
- A web app that lets users input data into a Google Sheet
- A script that automatically updates a Google Sheet with data from another
source - A tool that generates graphs and charts from data in a Google Sheet
- A service that sends data from a Google Sheet to another API or application
Connect Google Sheets#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_sheets: {
type: "app",
app: "google_sheets",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
},
})
},
})
Overview of FraudLabs Pro#
Fraud Detection for E-commerce
The FraudLabs Pro API enables e-commerce businesses to detect fraudulent orders
with ease. Businesses can simply send in an order’s information, and FraudLabs
Pro will return a fraud score and report explaining the decision. This allows
businesses to make informed decisions on whether to accept, flag, or reject an
order.
FraudLabs Pro can help e-commerce businesses in the following ways:
- Detect fraudulent orders
- Reduce chargebacks and fraud-related losses
- Prevent fraudsters from abusing the system
Here are some examples of what you can build with the FraudLabs Pro API:
- A fraud detection system for your e-commerce website
- A chargeback prevention system for your business
- A fraud monitoring system to track fraudsters and their activities
Connect FraudLabs Pro#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
fraudlabs_pro: {
type: "app",
app: "fraudlabs_pro",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.fraudlabspro.com/v1/order/screen`,
params: {
key: `${this.fraudlabs_pro.$auth.api_key}`,
ip: `[ip_address]`,
},
})
},
})
Related Videos#
Community Posts#
