With SeaTable, teams can easily organize all their tasks, assets, projects and ideas. It looks like a spreadsheet but structures any type of information, in the cloud or on your own server.
Go to siteThe SeaTable API allows you to interact programmatically with SeaTable databases. With it, you can create, update, and delete records, rows, and columns, manipulate tables, and manage users. In Pipedream, you can harness this API to automate data flows between SeaTable and other apps, trigger workflows based on changes in your SeaTable bases, and manipulate data without manual intervention. Think of it as connecting your spreadsheets' data to the wider web.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
seatable: {
type: "app",
app: "seatable",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://cloud.seatable.io/api2/account/info/`,
headers: {
Authorization: `Bearer ${this.seatable.$auth.account_token}`,
},
})
},
})
Automated Data Entry from Web Forms to SeaTable: Trigger a Pipedream workflow with a new form submission from Typeform. Extract the data and create a new row in a SeaTable base to keep track of survey results or lead information without lifting a finger.
Sync SeaTable Records with Google Calendar: Whenever a new event is added to a SeaTable base, such as a project deadline or a meeting, use Pipedream to create a corresponding event in Google Calendar. This ensures your schedule is always up-to-date across platforms.
Aggregate Social Media Metrics in SeaTable: Collect social media stats from platforms like Twitter or Facebook via their APIs and insert the data into SeaTable. Use Pipedream to run this workflow daily, giving you a clear, continually updated view of your social media performance metrics.
Deletes a specific row from a specified table. See the documentation
SeaTable uses OAuth authentication. When you connect your SeaTable account, Pipedream will open a popup window where you can sign into SeaTable and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any SeaTable API.
Pipedream requests the following authorization scopes when you connect your account:
GET
{{custom_fields.url}}/api/v2.1/dtable/app-access-token/
accept: application/json
GET
{{custom_fields.url}}/api/v2.1/dtable/app-access-token/