With Google AppSheet, you can build powerful solutions that simplify work. No coding required.
Go to siteAppsheets is a powerful API that allows you to quickly and easily create apps that can be used on a variety of devices, including smartphones, tablets, and computers. With Appsheet, you can easily create apps that allow you to track and manage your data, create reports and visualizations, and even share your data with other users. Appsheet is also easy to use, with a simple interface that makes it easy to get started.
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,
})
},
})
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 retrieve your API key,