Add the google_sheets connector on your Zenaton dashboard,
enter the credentials and authorize Zenaton to call the google_sheets API from your workflows.
Then add code snippet and URL path to your workflow.
const { workflow } = require("zenaton")
module.exports = workflow("MyWorkflow", function* () {
const google_sheets = this.connector(
'google_sheets',
'connector-id')
const response = yield google_sheets.get('path_to_API')
const params = {body: {param1: '...'}}
yield google_sheets.post('path_to_API', params)
})
We handle the complexity of orchestrating Google Sheets API calls and related logic in your code.
Add the connector to your Zenaton workflow and we manage the authentication, oauth1 and oauth2 flow including token refreshing.
If your Google Sheets API call fails, it can automatically be retried and you will receive an alert with error details.
View the Zenaton dashboard for execution history, scheduled tasks, errors and logs or retry failed Google Sheets API calls.
The Zenaton connector is a pre-configured task for calling the Google Sheets API inside your workflow with one line of code. Build custom integration logic by adding a workflow directly into your application using the functions in the Zenaton SDK.
// The Zenaton engine orchestrates google sheets API calls and related logic via the Zenaton agent. Every step is executed at the right moment on your servers and monitored on Zenaton dashboard.
const { workflow } = require("zenaton");
// google sheets authentification on Zenaton
module.exports = workflow("ParallelWorkflow", function* () {
const google sheets = this.connector(
'google sheets',
'your-connector-id-from-zenaton-dashboard'
);
// execute parallel tasks handled automatically by the Zenaton engine
const [a, b] = yield this.run.task(["TaskA"],["TaskB"]);
if (a > b) {
const response = yield google sheets.get('path_to_API');
} else {
yield this.run.task('TaskD');
}
});
const { workflow } = require("zenaton");
// google sheets authentification on Zenaton
module.exports = workflow("AsynchronousWorkflow", function* () {
const google sheets = this.connector(
'google sheets',
'your-connector-id-from-zenaton-dashboard'
);
this.run.task('TaskA');
this.google sheets.post('path_to_API');
yield run.task('TaskB');
yield this.run.task('TaskD');
});
// Tasks can be automatically (or manually) retried and executions are displayed in real-time on the Zenaton dashboard.
const { workflow, duration } = require("zenaton");
// google sheets authentification on Zenaton
module.exports = workflow("WaitWorkflow", function* () {
const google sheets = this.connector(
'google sheets',
'your-connector-id-from-zenaton-dashboard'
);
yield this.run.task('TaskA');
// The 'wait function is managed by the Zenaton engine and will be executed on your worker at the right time.
yield this.wait.for(duration.days(7));
yield google sheets.get('path_to_API');
});
const { workflow, duration } = require("zenaton");
module.exports = workflow("WaitEventWorkflow", function*() {
const google sheets = this.connector(
'google sheets',
'your-connector-id-from-zenaton-dashboard'
);
// Wait for up to 24 hours for the event using the Zenaton Wait Function.
const event = yield this.wait.event("MyEvent").for(duration.hours(24));
if (event) {
// If event has been triggered within 24 hours
yield this.run.task('TaskA');
} else {
// else calls google sheets API
yield google sheets.get('path_to_API');
}
}
});
Start building workflows
Sign-up and run a sample project Learn more
Zenaton
Product
Resources
Zenaton Examples