PostgreSQL

The World's Most Advanced Open Source Relational Database

Go to site

Integrate the PostgreSQL API with the Google Drive API

Setup the PostgreSQL API trigger to run a workflow which integrates with the Google Drive API. Pipedream's integration platform allows you to integrate PostgreSQL and Google Drive remarkably fast. Free for developers.

Upload File to Folder by File Path

Allows you to upload a file previously-saved to the /tmp directory, by passing in the path to that file

 
Try it
Upload File by URL

Upload a file to Google Drive by URL

 
Try it
Get Files

Gets or searches files.

 
Try it
Create a folder
 
Try it
Create File

Creates a new file.

 
Try it

Connect PostgreSQL

const { Client } = require('pg')

const { host, user, password, port, database } = auths.postgresql

const client = new Client({
  host,
  database,
  user,
  password,
  port,
})

await client.connect()
this.results = (await client.query("SELECT NOW()")).rows
await client.end()

Connect Google Drive

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://www.googleapis.com/oauth2/v1/userinfo`,
  headers: {
    Authorization: `Bearer ${auths.google_drive.oauth_access_token}`,
  },
})