• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Amelia to google sheets integration

I am trying to set up an integration between Amelia and Google Sheets. Here’s what I’m aiming to do:

  • I want to create a workflow where every new appointment made in Amelia is automatically added to a specific column in a Google Sheets file, based on the customer’s name.
  • Each column in the Google Sheet represents a different customer, and I want new appointments to be added to the next available row in that customer’s column.
So far, I have managed to connect Amelia and Google Sheets, but I’m having trouble with the following:

  1. Matching the customer’s name from Amelia to the correct column in Google Sheets.
  2. Automatically adding the new appointment to the next available row in that specific column.
Could anyone guide me through the exact steps I need to configure in Pabbly Connect to achieve this?

Here’s a quick summary of my setup:

  • Google Sheet with customer names as column headers.
  • Trigger: New Appointment in Amelia.
  • Action: Add the appointment data (e.g., time, date) to the correct customer column in Google Sheets.
 

Himesh

Active member
Hello @elinenispeling ,
After trigger add Lookup event from google sheet action to check the current record is availble or not and according to that add or update the column.

If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.
 

Preeti Paryani

Well-known member
Staff member
Hello @elinenispeling

We tried several workarounds to check if your use case is possible, but it seems it's not possible the way you want the data to be inserted in the Google Sheets.

But there is an alternative way if the Google Sheets structure would be changed, if the structure can be changed please let us know so we can assist you accordingly.
 

Preeti Paryani

Well-known member
Staff member
Hello @elinenispeling

In the alternative way, things will go like this:

1. Customer names will be placed in rows, we would require to add the customer Email as well as we may have multiple Customers with the same name.

2. As an appointment is made in Amelia we would look at the Google sheet for the specific customer using the email received from the trigger step.

3. Then we would update the cell value on the basis of the Row Index received from the lookup step.

The only drawback of this workflow is that only the latest appointment of the specific customer will be recorded.

We have created a sample workflow for you, please refer to the shared workflow link, also attaching the Google Sheets screenshot.

Workflow - https://connect.pabbly.com/workflow...JUG1cSAEFCF5TIFdOVlRWVVAqUh9WLQNGDD9fAVZ-B2Y#

Google Sheet Structure

1727968188937.png
 
Top