How to integrate of Google Sheets-Trello bundle using Zapier?

Integrate Google Sheets to Trello using Zapier. This short tutorial shows you how to automatically make new spreadsheet rows produce cards, optimizing your tasks and increasing efficiency.

Creating a new card in Trello when a new row is added to Google Sheets

How the integration works:

• A new row is created in a specific Google Sheets spreadsheet;
• Zapier creates a new card in Trello.

1. Creating a Zap. While on the “Home” tab, click the “Create” button:

2. Select “Zaps” from the dropdown menu.

Setting up the trigger event

3. Select the trigger event. This is an event that occurs in the trigger app, signaling Zapier to start the Zap.

4. Select the trigger event service.

5. Select “New Spreadsheet Row” in the dropdown menu and click “Continue.” The trigger will activate when a new row appears in the spreadsheet.

6. Next, you need to specify the “Google Sheets” account and click the “Continue” button.

7. Next, you need to specify the trigger settings by indicating the name of the spreadsheet and the sheet, then click the “Continue” button.

8. Then, you need to test the trigger by clicking the “Test trigger” button.

9. The next step is for the system to find the record and display all the available information. Click the “Continue with selected record” button.

10. This is what the data sent to the Google spreadsheet looks like:

Setting up an action in the “Trello” service.

11. Select the action service.

12. In the next window, you need to specify the action that will be performed when a new row appears. Select “Create Card” from the dropdown menu and click “Continue.”

13. Next, you need to specify the “Trello” account and click the “Continue” button.

14. Next, you need to configure the connection between the “Google Sheets” and “Trello” applications. Fill in the required fields and the fields into which the data should be imported by substituting variables from the dropdown list. After filling in all the necessary fields, click the “Continue” button.

15. You need to test the “Google Sheets” – “Trello” connection.

16. Test data has been sent to “Trello.”

17. Check the test data in the “Trello” application.

18. After a successful test, click the “Publish” button.

The Zap has been created, configured, and activated.