bit.io
The immediately productive, shareable cloud database. Bit.io is a zero-config, scalable cloud database with the social and community features of GitHub.
Integrate the bit.io API with the Google Sheets API
Setup the bit.io API trigger to run a workflow which integrates with the Google Sheets API. Pipedream's integration platform allows you to integrate bit.io and Google Sheets remarkably fast. Free for developers.
Popular bit.io and Google Sheets 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.
Overview of bit.io#
The Bit.io API lets you build applications that interact with the Bit.io platform. Using the API, you can do things like:
- Query information about Bit.io accounts and transactions
- Create and manage Bit.io addresses
- Send and receive Bit.io payments
- Generate Bit.io invoices
- Integrate Bit.io into your own applications
Connect bit.io#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
bit_io: {
type: "app",
app: "bit_io",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.bit.io/api/v1beta/repos`,
headers: {
Authorization: `Bearer ${this.bit_io.$auth.api_key}`,
},
})
},
})
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}`,
},
})
},
})
Related Videos#
Community Posts#
