What do you want to automate

with Google Appsheet and Google Maps (Places API)?

Prompt, edit and deploy AI agents that connect to Google Appsheet, Google Maps (Places API) 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 the Google Appsheet API

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

 
Try it
Get Place Details with the Google Maps (Places API) API

Retrieves detailed information for a specific place using its Place ID. 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
Search Places with the Google Maps (Places API) API

Searches for places based on location, radius, and optional filters like keywords, place type, or name. 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 Google Appsheet API with the Google Maps (Places API) API
Setup the Google Appsheet API trigger to run a workflow which integrates with the Google Maps (Places API) API. Pipedream's integration platform allows you to integrate Google Appsheet and Google Maps (Places API) remarkably fast. Free for developers.

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,
    })
  },
})

Overview of Google Maps (Places API)

The Google Maps (Places API) offers detailed information about physical locations, including places of interest, reviews, and other metadata. In Pipedream, you can leverage this API to create dynamic workflows that respond to location data. Whether you're building apps that track asset locations, automate location-based alerts, or provide users with local info, integrating with Google Maps can add a powerful spatial context to your services.

Connect Google Maps (Places API)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_maps_platform: {
      type: "app",
      app: "google_maps_platform",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      method: "post",
      url: `https://maps.googleapis.com/maps/api/place/findplacefromtext/json`,
      params: {
        key: `${this.google_maps_platform.$auth.api_key}`,
        input: `Museum of Contemporary Art Australia`,
        inputtype: `textquery`,
      },
    })
  },
})

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