Get Rows with Google Appsheet API on New Worker Created from Workday API

Pipedream makes it easy to connect APIs for Google Appsheet, Workday and 3,000+ other apps remarkably fast.

Trigger workflow on

New Worker Created from the Workday API

Next, do this

Get Rows with the Google Appsheet API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Workday trigger and Google Appsheet action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Worker Created trigger
1. Connect your Workday account
2. Configure timer
Configure the Get Rows action
1. Connect your Google Appsheet account
2. Configure Table Name
3. Optional- Configure Row
4. Optional- Configure Selector
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Worker Created on Workday

Description:Emit new event for each new worker created in Workday. [See the documentation](https://community.workday.com/sites/default/files/file-hosting/restapi/#common/v1/get-/workers)

Version:0.0.2

Key:workday-new-worker-created

View on GitHub

Trigger Code#

import common from "../common/base-polling.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "workday-new-worker-created",
  name: "New Worker Created",
  description: "Emit new event for each new worker created in Workday. [See the documentation](https://community.workday.com/sites/default/files/file-hosting/restapi/#common/v1/get-/workers)",
  version: "0.0.2",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    _getPreviousIds() {
      return this.db.get("previousIds") || {};
    },
    _setPreviousIds(ids) {
      this.db.set("previousIds", ids);
    },
    generateMeta(worker) {
      return {
        id: worker.id,
        summary: `New worker created: ${worker.descriptor}`,
        ts: Date.now(),
      };
    },
    async processEvent(limit) {
      const results = this.workday.paginate({
        fn: this.workday.listWorkers,
      });

      const previousIds = this._getPreviousIds();
      let workers = [];

      for await (const worker of results) {
        if (previousIds[worker.id]) {
          continue;
        }
        workers.push(worker);
        previousIds[worker.id] = true;
      }

      this._setPreviousIds(previousIds);

      if (!workers?.length) {
        return;
      }

      if (limit) {
        workers = workers.slice(0, limit);
      }

      for (const worker of workers) {
        const meta = this.generateMeta(worker);
        this.$emit(worker, meta);
      }
    },
  },
  hooks: {
    async deploy() {
      await this.processEvent(25);
    },
  },
  async run() {
    await this.processEvent();
  },
  sampleEmit,
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Workday	`workday`	`app`	This component uses the Workday app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`

Trigger Authentication#

Workday uses OAuth authentication. When you connect your Workday account, Pipedream will open a popup window where you can sign into Workday and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Workday API.

Pipedream requests the following authorization scopes when you connect your account:

About Workday#

The AI platform for people, money, and agents

Action#

Get Rows on Google Appsheet

Description:Read existing records in a table in the AppSheet app. [See the documentation](https://support.google.com/appsheet/answer/10104797?hl=en&ref_topic=10105767&sjid=1665780.0.1444403316-SA#)

Version:0.0.2

Key:google_appsheet-get-rows

View on GitHub

Google Appsheet Overview#

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.

Action Code#

import common from "../common/base.mjs";

export default {
  ...common,
  key: "google_appsheet-get-rows",
  name: "Get Rows",
  description: "Read existing records in a table in the AppSheet app. [See the documentation](https://support.google.com/appsheet/answer/10104797?hl=en&ref_topic=10105767&sjid=1665780.0.1444403316-SA#)",
  version: "0.0.2",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: true,
  },
  type: "action",
  props: {
    ...common.props,
    selector: {
      type: "string",
      label: "Selector",
      description: "You can specify an expression to select and format the rows returned. **Example: Filter(TableName, [Column] = \"Value\")** [See the documentation](https://support.google.com/appsheet/answer/10105770?hl=en&ref_topic=10105767&sjid=3242006823758562345-NC)",
      optional: true,
    },
    row: {
      propDefinition: [
        common.props.appsheet,
        "row",
      ],
      description: "You can also filter the results using the `Row` value. The `Row` value may contain field values of the key field values of the record to be retrieved. **Example:** `{ \"First Name\": \"John\" }`",
      optional: true,
    },
  },
  methods: {
    ...common.methods,
    getAction() {
      return "Find";
    },
    getData() {
      return this.selector
        ? {
          Properties: {
            Selector: this.selector,
          },
        }
        : {};
    },
    getSummary(response) {
      return `Successfully retrieved ${ response.length || 0} rows`;
    },
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Google Appsheet	`appsheet`	`app`	This component uses the Google Appsheet app.
Table Name	`tableName`	`string`	Name of the table. Select Data > Tables and expand the table details to view the table name.
Row	`row`	`object`	You can also filter the results using the `Row` value. The `Row` value may contain field values of the key field values of the record to be retrieved. Example: `{ "First Name": "John" }`
Selector	`selector`	`string`	You can specify an expression to select and format the rows returned. Example: Filter(TableName, [Column] = "Value") See the documentation

Action Authentication#

Google Appsheet uses API keys for authentication. When you connect your Google Appsheet account, Pipedream securely stores the keys so you can easily authenticate to Google Appsheet APIs in both code and no-code steps.

To enable the API:

Open the app in the app editor.
Select Settings > Integrations.
Under IN: from cloud services to your app, enable the Enable toggle. This enables the API for the application as a whole.
Ensure that at least one unexpired Application Access Key is present. Otherwise, click Create Application Access Key.
When you are done, save the app by selecting one of the following: