What do you want to automate

with Neon Postgres and Guru?

Prompt, edit and deploy AI agents that connect to Neon Postgres, Guru and 2,500+ other apps in seconds.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Add Tag to Card with Guru API on New Column from Neon Postgres API
Neon Postgres + Guru
 
Try it
Add Tag to Card with Guru API on New or Updated Row from Neon Postgres API
Neon Postgres + Guru
 
Try it
Add Tag to Card with Guru API on New Row Custom Query from Neon Postgres API
Neon Postgres + Guru
 
Try it
Add Tag to Card with Guru API on New Row from Neon Postgres API
Neon Postgres + Guru
 
Try it
Add Tag to Card with Guru API on New Table from Neon Postgres API
Neon Postgres + Guru
 
Try it
Card Updated (Instant) from the Guru API

Emit new event when a user makes an edit to a card. See the documentation

 
Try it
New Announcement Read (Instant) from the Guru API

Emit new event when a user clicks on the "I read it" button in an Announcement. See the documentation

 
Try it
New Column from the Neon Postgres API

Emit new event when a new column is added to a table. See the documentation

 
Try it
New Card Created (Instant) from the Guru API

Emit new event when a new card is published. See the documentation

 
Try it
New or Updated Row from the Neon Postgres API

Emit new event when a row is added or modified. See the documentation

 
Try it
Delete Row(s) with the Neon Postgres API

Deletes a row or rows from a table. See the documentation

 
Try it
Add Tag to Card with the Guru API

Links an existing tag to a specified card in Guru. See the documentation

 
Try it
Execute SQL Query with the Neon Postgres API

Execute a custom PostgreSQL query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Find Row with the Neon Postgres API

Finds a row in a table via a lookup column. See the documentation

 
Try it
Create Card with the Guru API

Creates a new card on your Guru account. See the documentation

 
Try it
Integrate the Neon Postgres API with the Guru API
Setup the Neon Postgres API trigger to run a workflow which integrates with the Guru API. Pipedream's integration platform allows you to integrate Neon Postgres and Guru remarkably fast. Free for developers.

Connect Neon Postgres

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
import { axios } from "@pipedream/platform";
import { neon } from "@neondatabase/serverless";

export default defineComponent({
  props: {
    neon_postgres: {
      type: "app",
      app: "neon_postgres",
    }
  },
  async run({ steps, $ }) {

    const { host, port, user, password, database } = this.neon_postgres.$auth
    const connectionString = `postgresql://${user}:${password}@${host}:${port}/${database}`  
    
    const sql = neon(connectionString)
    const result = await sql`SELECT version()`
    const { version } = result[0]
    return version

  },
})

Overview of Guru

The Guru API on Pipedream enables the automation of knowledge sharing and management tasks within your team or organization. Using this API, you can programmatically interact with Guru's knowledge base, including retrieving card details, creating new cards, and updating existing content. By leveraging Pipedream's serverless platform, you can craft workflows that trigger based on events from other services, process the data, and perform actions in Guru to keep your team's knowledge up to date and accessible.

Connect Guru

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    guru: {
      type: "app",
      app: "guru",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.getguru.com/api/v1/teams`,
      headers: {
        "Accept": `application/json`,
      },
      auth: {
        username: `${this.guru.$auth.username}`,
        password: `${this.guru.$auth.api_key}`,
      },
    })
  },
})

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo