What do you want to automate

with FTrack and Google Appsheet?

Prompt, edit and deploy AI agents that connect to FTrack, Google Appsheet 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 Row with Google Appsheet API on New Project Added from FTrack API
FTrack + Google Appsheet
 
Try it
Add Row with Google Appsheet API on New Task Added from FTrack API
FTrack + Google Appsheet
 
Try it
Add Row with Google Appsheet API on Status Changed from FTrack API
FTrack + Google Appsheet
 
Try it
Delete Row with Google Appsheet API on New Project Added from FTrack API
FTrack + Google Appsheet
 
Try it
Delete Row with Google Appsheet API on New Task Added from FTrack API
FTrack + Google Appsheet
 
Try it
New Project Added from the FTrack API

Triggered when a new task is added. See the documentation

 
Try it
New Task Added from the FTrack API

Triggered when a new task is added. See the documentation

 
Try it
Status Changed from the FTrack API

Triggered when the status of an item is changed. See the documentation

 
Try it
Get Task Info with the FTrack API

Get information about a task. See the documentation

 
Try it
Add Row with the Google Appsheet API

Adds a new row to a specific table in the AppSheet app. See the documentation

 
Try it
List Schemas with the FTrack API

List all schemas. See the documentation

 
Try it
Delete Row with the Google Appsheet API

Deletes a specific row from a table in the AppSheet app. See the documentation

 
Try it
Get Rows with the Google Appsheet API

Read existing records in a table in the AppSheet app. See the documentation

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

Overview of FTrack

The FTrack API is a powerhouse for creative project management, enabling users to automate and integrate a wide array of tasks related to project tracking, asset management, and team collaboration. With Pipedream, you can harness this API to create custom workflows that trigger actions within FTrack or connect it with other apps to streamline your creative operations. It's a toolset for improving efficiency by automating repetitive tasks, syncing data across applications, and orchestrating complex project management activities.

Connect FTrack

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: {
    ftrack: {
      type: "app",
      app: "ftrack",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      method: "POST",
      url: `https://${this.ftrack.$auth.subdomain}.ftrackapp.com/api`,
      headers: {
        "Content-Type": `application/json`,
        "ftrack-user": `${this.ftrack.$auth.username}`,
        "ftrack-api-key": `${this.ftrack.$auth.api_key}`,
      },
      data: []
    })
  },
})

Overview of Google Appsheet

The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.

Connect Google Appsheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_appsheet: {
      type: "app",
      app: "google_appsheet",
    }
  },
  async run({steps, $}) {
    const data = {
      "Action": "Find",
      "Properties": `{
          "Locale": "en-US",
          "Selector": "Filter(Sheet1, true)",
          "Timezone":
          "Pacific Standard Time"
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
      headers: {
        "ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
      },
      data,
    })
  },
})

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