- How to automatically mark tasks as completed in Todoist when new rows appear in Google Sheets
- 1. Set the Google Sheets trigger as “New row added”
- 2. Add the “Complete task" step in Todoist
- 3. Activate your playbook
- Learn more about integrating with Google Sheets and Todoist
- Related blog posts
- More how-to guides featuring Google Sheets and Todoist
How to automatically mark tasks as completed in Todoist when new rows appear in Google Sheets
Set the Google Sheets trigger as “New row added”
Add the Google Sheets trigger to initiate your playbook's actions for every new row added.
To do this, click "Add trigger" in your playbook. Select the "New row added" trigger option from the dropdown menu under Google Sheets. It will enable your playbook to automatically identify newly added rows and trigger necessary actions.
If you still need to connect your Google Sheets account to Relay.app, a prompt will guide you through the connection process.
Add the “Complete task" step in Todoist
Integrate the Todoist automation into your playbook to ensure prompt task completion in Todoist when new rows appear in Google Sheets.
Click the "Add step" button, then locate the "Complete task" automation for Todoist and input the mandatory and relevant details.
If your Todoist account still needs to be connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Todoist account.
Activate your playbook
Activating your playbook is the last step in the process. Once you turn it on, it will automatically mark tasks as completed in Todoist when new rows appear in Google Sheets without requiring manual intervention.
To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.