Skip to main content
Glama

mcp-google-sheets

index.ts10.5 kB
import { PiecePropValueSchema, Property } from '@activepieces/pieces-framework'; import { flowluAuth } from '../..'; import { FlowluClient } from './client'; export function makeClient( auth: PiecePropValueSchema<typeof flowluAuth> ): FlowluClient { const client = new FlowluClient(auth.domain, auth.apiKey); return client; } function mapItemsToOptions(items: { id: string | number; name: string }[]) { return items.map((item) => ({ label: item.name, value: item.id })); } export const flowluCommon = { task_id: (required = true) => Property.Dropdown({ displayName: 'Task ID', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllTasks(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), user_id: (required = true, displayName = 'User ID') => Property.Dropdown({ displayName, required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllUsers(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), workflow_id: (required = false) => Property.Dropdown({ displayName: 'Task Workflow ID', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllTaskWorkflow(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), workflow_stage_id: (required = false) => Property.Dropdown({ displayName: 'Task Workflow Status ID', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllTaskStages(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), honorific_title_id: (required = false) => Property.Dropdown({ displayName: 'Title', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const res = await client.listAllHonorificTitles(); const { response } = res; return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), account_category_id: (required = false) => Property.Dropdown({ displayName: 'Account Category', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllAccountCategories(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), industry_id: (required = false) => Property.Dropdown({ displayName: 'Account Industry', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllAccountIndustries(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), source_id: (required = false) => Property.Dropdown({ displayName: 'Opportunity Source', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllOpportunitySources(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), opportunity_id: (required = false) => Property.Dropdown({ displayName: 'Opportunity ID', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllOpportunities(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), account_id: ( required = false, displayName = 'Account ID', description = '' ) => Property.Dropdown({ displayName, description, required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllAccounts(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), contact_id: ( required = false, displayName = 'Contact ID', description = '' ) => Property.Dropdown({ displayName, description, required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listAllContacts(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), pipeline_id: (required = false) => Property.Dropdown({ displayName: 'Sales Pipeline ID', required, refreshers: [], options: async ({ auth }) => { if (!auth) { return { disabled: true, placeholder: 'Connect your account first', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listSalesPipelines(); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), pipeline_stage_id: (required = false) => Property.Dropdown({ displayName: 'Sales Pipeline Stage ID', required, refreshers: ['pipeline_id'], options: async ({ auth, pipeline_id }) => { if (!auth || !pipeline_id) { return { disabled: true, placeholder: 'Connect your account first and select sales pipeline.', options: [], }; } const client = makeClient( auth as PiecePropValueSchema<typeof flowluAuth> ); const { response } = await client.listSalesPipelineStages( pipeline_id as number ); return { disabled: false, options: response.items.map((item) => { return { label: item.name, value: item.id, }; }), }; }, }), };

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/activepieces/activepieces'

If you have feedback or need assistance with the MCP directory API, please join our Discord server