Automatically Add New Smartsheet Rows to Google Sheets with Pabbly Connect

Learn how to use Pabbly Connect to automatically add new Smartsheet rows to Google Sheets without coding. Follow our step-by-step tutorial! Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Start Your Integration

Pabbly Connect is the automation platform that will help you integrate Smartsheet with Google Sheets automatically. To begin, open your web browser and navigate to the Pabbly website by typing Pabbly.com. Once on the homepage, hover over the ‘Products’ option and click on ‘Connect’.

If you don’t have an account, you can set up a free Pabbly Connect account quickly. Click on the ‘Sign Up Free’ button, fill in the required details, and create your account. After signing in, you will land on the All Apps section. From there, click on ‘Access Now’ under the Pabbly Connect panel to start creating your workflow.

2. Create a Workflow in Pabbly Connect

Now that you have accessed Pabbly Connect, it’s time to create a workflow. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard. You will be prompted to name your workflow; for this example, let’s call it Smartsheet Data to Google Sheets. Click on ‘Create’ to proceed.

In your newly created workflow, you will see two sections: Trigger and Action. The trigger will be the event of adding new data in Smartsheet, and the action will be sending that data to Google Sheets as a new row. Click on the Trigger section and select Smartsheet from the list of applications.

• Choose Smartsheet as the application.
• Select ‘New Row’ as the trigger event.
• Click on the ‘Connect’ button to establish a connection.

After clicking on ‘Connect’, you will need to add a new connection by providing an API token from your Smartsheet account. This step is crucial as it allows Pabbly Connect to access your Smartsheet data.

3. Configure Smartsheet in Pabbly Connect

To get the API token, navigate to your Smartsheet account settings. Click on the account icon, go to ‘Personal Settings’, and select ‘API Access’. Here, you can generate a new access token by clicking on ‘Generate New Access Token’. Name your token appropriately and copy it.

Return to Pabbly Connect and paste the token into the API token field, ensuring to prefix it with ‘Bearer ‘. Once the connection is established, select the specific sheet you want to monitor in Smartsheet. For our example, we will choose the sheet named Vaccination Status of Employees.

• Select the sheet from the drop-down list.
• Name your webhook for easy identification.
• Leave the column ID blank unless specific targeting is needed.

Once configured, Pabbly Connect will be ready to listen for new rows added to your Smartsheet.

4. Collect New Row Data from Smartsheet

After setting up your Smartsheet connection, Pabbly Connect will wait for new data. To trigger this, you need to add a new row in your Smartsheet. Enter the details of an employee, such as their name, email, vaccination status, and date. Once you save this new row, Pabbly Connect will capture this data. using Pabbly Connect

In Pabbly Connect, you will see a notification indicating that it is waiting for a response. After a minute or two, the new row data will be captured. You should see the event type and object type displayed in Pabbly Connect, confirming that the new row has been detected.

Ensure the new row is filled out correctly in Smartsheet. Check back in Pabbly Connect for the captured response. Proceed to map the row data for the next step.

Once the data is successfully captured, you can move on to the next step of sending this data to Google Sheets.

5. Send Data to Google Sheets as a New Row

Now that you have collected the new row data from Smartsheet, it’s time to send this information to Google Sheets. In Pabbly Connect, click on the Action section and select Google Sheets as the application. For the action event, choose ‘Add New Row’.

Click on the ‘Connect’ button and select ‘Add New Connection’. You will need to authorize Pabbly Connect to access your Google Sheets. Choose the appropriate Google account and allow the necessary permissions. Once connected, select the specific spreadsheet where you want the data to be added.

Select the spreadsheet named Vaccination Status of Employees. Map the fields from Smartsheet to the corresponding columns in Google Sheets. Click on ‘Save and Send Test Request’ to finalize the integration.

After completing these steps, your new row data will be automatically added to Google Sheets whenever a new row is created in Smartsheet. This integration will save you time and reduce manual data entry errors.

Conclusion

Using Pabbly Connect, you can seamlessly integrate Smartsheet with Google Sheets to automatically add new rows. This process eliminates the need for manual data entry, ensuring that your data is always up-to-date. By following the steps outlined in this tutorial, you can easily set up this integration and streamline your workflow.