with Columns Ai and Google Docs?
Emit new event when a new document is created in Google Docs. See the documentation
Emit new event when a document is created or updated in Google Docs. See the documentation
Builds a graph object from scratch and publishes it. See the documentation
Builds a graph object from a template and publishes it. See the documentation
Appends an image to the end of a document. See the documentation
import { ChartType } from 'columns-graph-model';
import { Columns } from 'columns-sdk';
export default defineComponent({
props: {
columns_ai: {
type: "app",
app: "columns_ai",
}
},
async run({steps, $}) {
const rows = [{
"value": 312,
"state": "WA",
"parent": "US"
}];// rows is an example data set where you should organize your data in a similar way.
//Instantiates a Columns SDK object with your API Key.
const columns = new Columns(this.columns_ai.$auth.api_key);
const data = columns.data(['state'], ['value'], rows);
const graph = columns.graph(data);
// switch to different chart types: BAR, PIE, DOUGHGUT, LINE, AREA, SCATTER, etc.
graph.type = ChartType.COLUMN;
// customise the graph (lots of options in its data model)
graph.settings.general.palette = ['#ff0000', '#00ff00', '#0000ff'];
graph.settings.general.background = '#00000002';
return graph;
},
})
The Google Docs API allows you to create, read, and update Google Docs programmatically, enabling a wide range of automations and integrations with other apps and services. With Pipedream, you can harness this API to craft custom serverless workflows that trigger on various events, like form submissions, emails, or scheduled times, and perform actions like updating a document, extracting content, or even generating templated reports.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_docs: {
type: "app",
app: "google_docs",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/drive/v3/about?fields=user`,
headers: {
Authorization: `Bearer ${this.google_docs.$auth.oauth_access_token}`,
},
})
},
})