Overview

Learn how to integrate Awaz.ai with Google Sheets using Zapier to automate call logging and initiation. We’ll cover two use cases:

✔ Scenario A: Logging Awaz.ai call events into a Google Sheets spreadsheet for tracking and reporting.

✔ Scenario B: Triggering Awaz.ai calls whenever new or updated rows appear in Google Sheets.

Follow these step-by-step instructions to connect Awaz.ai with Google Sheets, map data fields (like call details and contact info), and ensure smooth automation. We’ll also provide troubleshooting tips, best practices, and screenshots for an easy setup experience.

Scenario A: Log Awaz.ai Call Events in Google Sheets

Goal:

Automatically record details of each Awaz.ai call into a Google Sheets row. For example, when an AI call is completed, you want to log the call date, contact, agent, and outcome in a spreadsheet for tracking.

Step 1: Set Up the Awaz.ai Trigger in Zapier

Create a Zap and choose Awaz.ai as the Trigger app: Log in to your Zapier account and click Create Zap. In the Zap editor, search for “Awaz.ai” as the trigger app.
Select the trigger event – “New Call”: From the Awaz.ai triggers list, choose New Call. This trigger fires whenever an Awaz.ai call is finished (Awaz.ai Webhooks by Zapier Integration - Quick Connect - Zapier). (Alternatively, Awaz.ai also offers an Agent Trigger event, which fires when your AI agent triggers an action during a live call (Awaz.ai Webhooks by Zapier Integration - Quick Connect - Zapier), but for logging completed calls, “New Call” is ideal.)
Connect your Awaz.ai account: If this is your first Awaz Zap, you’ll be prompted to connect your Awaz.ai account. Click Connect and follow the instructions. Typically, you will need to provide an API key or authenticate via Awaz.ai. Log in with your Awaz.ai credentials or paste your API key (find this in your Awaz.ai dashboard under Integration or API settings). Zapier will test the connection and confirm it’s working.
Test the trigger: After connecting, click Test Trigger. Zapier will fetch a recent call event from Awaz.ai to use as sample data. If you have recently completed an Awaz call, it should retrieve that. If no sample is found, you may need to initiate a test call via Awaz.ai first. Once a sample is loaded, you’ll see fields such as contact name/number, call status, agent name/ID, call timestamp, etc. This confirms the trigger is set up correctly.
Step 2: Configure the Google Sheets Action to Log the Data
Choose Google Sheets as the Action app: In your Zap, click + to add an action step. Select Google Sheets as the app.
Select the action event – “Create Spreadsheet Row”: From the list of Google Sheets actions, choose Create Spreadsheet Row (under “Write”). This will append a new row to your chosen sheet for each Awaz call event.
Connect your Google Sheets account: If not connected already, sign into Google Sheets through Zapier and authorize access.
Set up the Google Sheets template: Choose the Spreadsheet and Worksheet where you want to log calls. It’s a good idea to prepare a sheet with column headers like Date, Contact Name, Phone Number, Agent, Call Status, Call Summary, etc., before mapping fields. Select that sheet in the Zap setup.
Map Awaz.ai fields to sheet columns: Zapier will display the columns from your sheet. For each relevant column, click in the field and select the corresponding Awaz.ai data from the trigger sample. For example:
- Date: map to the Awaz.ai call timestamp (or use Zapier’s Timestamp if provided).
- Contact Name: map to the caller’s name field from Awaz (if your Awaz call had the name, or use phone as identifier if name is not available).
- Phone Number: map to the phone number field of the contact.
- Agent: map to the Awaz agent ID or name (Awaz may provide an “Agent” field indicating which AI agent handled the call (Awaz.ai Webhooks by Zapier Integration - Quick Connect - Zapier)).
- Call Status: map to the call outcome/status field (e.g., “completed”, “failed”) (Awaz.ai Google Sheets Integration - Quick Connect - Zapier).
- Call Summary/Notes: if Awaz provides a transcript summary or any notes field, map it here. (If not directly provided by Awaz trigger, you might leave this blank or consider using an Awaz “Agent Trigger” to capture specific info during the call.)
  Ensure each column you want filled has the appropriate Awaz field. You can leave optional fields blank.
Mapping Awaz.ai call data to Google Sheets columns. In Zapier’s setup, choose your sheet and map fields like Contact Name, Phone, Agent ID, Call Status, etc., from the Awaz trigger to the corresponding columns. (Awaz.ai Google Sheets Integration - Quick Connect - Zapier) (Awaz.ai Google Sheets Integration - Quick Connect - Zapier)
Test the action: Click Test & Review or Test & Continue. Zapier will send the sample call data to Google Sheets, creating a new row. Go to your Google Sheet to verify that a new row appears with the correct data in each column. For example, you should see the sample contact’s name, phone, and call details populated. If something looks wrong (e.g., data in wrong column or missing), adjust the mapping and retest.
Name and turn on the Zap: Give your Zap a clear name like “Log Awaz Calls to Sheet”. Toggle it On. Now, whenever an Awaz.ai call completes, Zapier will automatically add a row to your Google Sheets log.

Step 3: Best Practices & Troubleshooting for Google Sheets Logging

Sheet structure: It’s best to dedicate a specific worksheet for these call logs. Avoid having Zapier write to a sheet that you or others are editing frequently. If you need to use the data elsewhere, you can reference this log sheet.
Column mapping issues: If you add new columns or change headers in Google Sheets after setting up the Zap, click Refresh Fields in the Zap editor to fetch the latest sheet structure, then remap as needed (Cannot map the right fields from an input form to ... - Zapier Community). Unmapped required fields will cause errors, so always update the Zap if the sheet changes.
Date/time format: Awaz.ai might output timestamps in a specific format (e.g., ISO 8601). Google Sheets can often auto-recognize these, but if not, you can use a Formatter step in Zapier to format the date/time before inserting. Alternatively, have Sheets format the column (e.g., date/time format).
Missing data: If some Awaz trigger fields appear blank in the sheet, ensure that data is actually captured by Awaz. For instance, if “Contact Name” isn’t coming through, you might only have the phone number – consider using the phone as a unique ID or updating your Awaz call setup to include name information.
Zap runs but no row appears: Check the Zap History in Zapier for errors. Common issues include: the Google Sheet couldn’t be found (make sure the spreadsheet is not moved or renamed), or a Google API limit issue (rare for adding single rows). Also ensure the Zap is ON and you have not exceeded your Zapier task quota.
Concurrent calls: If multiple Awaz calls happen around the same time, Zapier will queue them. Each will still add a row, though not exactly simultaneously. This usually isn’t an issue, but just be aware in case of very high call volume (in which case, also ensure your Google Sheets can handle many appended rows quickly).

Best Practice Tip: Organize Your Data

Consider adding a unique ID for each call logged (perhaps Awaz provides a Call ID). Logging a call ID or using the timestamp as an ID can help if you need to correlate this data with other systems. Also, if you want to analyze call logs (e.g., count calls per day), having them in Google Sheets is useful – you can use Sheets’ functions or connect to Data Studio, etc.

Scenario B: Trigger Awaz.ai Calls from Google Sheets Entries

Goal:

Automatically initiate an Awaz.ai outbound call whenever a new row is added (or an existing row is updated) in a Google Sheets document. For example, if someone fills out a Google Form linked to a sheet or you add a lead into a sheet, Awaz.ai will call that contact (perhaps to follow up or provide information).

Step 1: Set Up the Google Sheets Trigger

Create a new Zap and select Google Sheets as the Trigger app: Go to Zapier and Create Zap. Choose Google Sheets for the trigger.
Select the trigger event: If you want to trigger on new rows, choose New Spreadsheet Row (Awaz.ai Google Sheets Integration - Quick Connect - Zapier). If you also need to react to updates in existing rows, you can use New or Updated Spreadsheet Row (available if your sheet is on a Team Drive or by using a specific Zapier trigger). Alternatively, you can design your sheet so that new rows are used for new calls, and updates trigger calls by using a separate “flag” column and the New or Updated Row trigger (Awaz.ai Google Sheets Integration - Quick Connect - Zapier). For simplicity, we’ll assume new rows trigger calls.
Connect your Google Sheets account: If not done already, connect and authorize the Google account where your spreadsheet lives.
Configure the trigger options: Select the Spreadsheet and Worksheet to monitor. If using “New Spreadsheet Row”, just specify the sheet. If using “New or Updated Row”, you may also need to specify a Trigger Column (a specific column that, when edited, signals an update) (Awaz.ai Google Sheets Integration - Quick Connect - Zapier). For example, you might have a column “Status” that you update to “Needs Call” to trigger the Zap.
Test the trigger: Zapier will pull in a sample row. Ensure the sample has the columns filled that you expect (e.g., Name, Phone, etc.). If the sheet is empty, add a dummy row to test. Once a sample is loaded, continue.

Step 2: Configure the Awaz.ai “Make a Call” Action
Choose Awaz.ai as the Action app: Add an Action step, select Awaz.ai.
Select the action event – “Make a Call”: Choose Make a Call as the action. This will instruct Awaz.ai to initiate an outbound call to a contact (Awaz.ai Webhooks by Zapier Integration - Quick Connect - Zapier).
Connect Awaz.ai account: If not connected in this Zap yet, you’ll be prompted to do so (you can reuse the connection from Scenario A if created).
Set up the call details (Action Template): Now, map the Google Sheets fields to the Awaz.ai call fields:
- Agent ID: Select which Awaz.ai agent should handle the call. This might be a dropdown of your available AI agents. Choose the appropriate agent for this scenario (for instance, a specific agent designed to handle new lead calls or follow-ups). If your agent is dynamic (less likely), you could have an Agent ID in your sheet and map it. Otherwise, it’s usually a static selection.
- From Number: (If applicable) This field is the caller ID or number that Awaz will dial out from. Some Awaz.ai accounts have multiple outbound numbers or a default. If required, enter or select your business phone number that should appear for the recipient. If Awaz.ai only has one default number, this might be optional.
- Contact Name: Map this to the name field from your Google Sheet. For example, if your sheet has a “Name” column, click that value from the trigger data. This helps Awaz.ai personalize the call (and possibly for your records).
- Contact Phone Number: Map this to the phone number column from the sheet. This is crucial – ensure the number is in a proper format (including country code if international). E.g., “+1 2125551234” for US. If your sheet’s phone numbers are not standardized, you may need a Formatter step to clean them (e.g., remove dashes, etc.).
- Call DateTime: If you want the call to happen at a specific scheduled time, map a date/time from your sheet. For instance, if the sheet has a column “Preferred Call Time” or the row was added with a scheduled time, use that. Format: Awaz.ai likely expects an ISO timestamp or specific format (check Awaz.ai docs if unsure). If you leave this blank, Awaz.ai will call immediately once the Zap runs. For immediate calls upon new row, leave this empty. For scheduling, ensure the datetime includes timezone or is in UTC as required. (You can also use Zapier’s Delay action before the call step as an alternative scheduling method – e.g., “Delay 1 hour” if you want to call later.)
- (Other fields if available, like Email or custom fields: Awaz’s “Make a Call” action mainly needs the above. You might also see fields for passing additional info or selecting if the contact should be saved – not in the trigger snippet we saw, but Awaz has an “Add or Update Contact” action separately (Awaz.ai Google Sheets Integration - Quick Connect - Zapier). In the “Make a Call” step, stick to the core fields to initiate the call.)
Example: Suppose your Google Sheet “Leads” has columns: Name, Phone, Product Interest, Scheduled Call Time. You’d select your Awaz agent, map Name -> Contact Name, Phone -> Contact Phone, and Scheduled Call Time -> Call DateTime. This way, whenever a new lead is added with those details, Awaz.ai will place a call using your AI agent to the provided phone at the specified time (or immediately if no time given).

Configuring the Awaz.ai “Make a Call” action in Zapier. Here we map data from Google Sheets: the lead’s name and phone number are inserted into the Contact fields, and we select an Awaz.ai agent ID to handle the call (Awaz.ai Salesforce Integration - Quick Connect - Zapier) (Awaz.ai Salesforce Integration - Quick Connect - Zapier). Ensure the phone number is properly formatted and include a Call DateTime if scheduling the call for later.
Test the action: Be cautious testing this step – it will actually attempt a call. You might want to use a dummy/test phone number (perhaps your own phone or a colleague’s) in the sample row. Click Test & Continue. Awaz.ai should attempt the call with the sample data. Verify that you (or the test recipient) receive a call. If the call connects, great – it means Awaz received the instruction. You don’t necessarily need to answer unless you want to hear the AI agent. If testing is not feasible (you don’t want to actually call someone during setup), you can skip the live test and just proceed to turning on the Zap, but be sure your mapping is correct.
Turn on the Zap: Name it (e.g., “Trigger Awaz Call from Google Sheets”) and enable it. Now every new (or updated) row on that sheet will cause Awaz.ai to call the specified contact.

Step 3: Best Practices & Troubleshooting for Sheets-to-Call

Use a dedicated sheet or clear trigger criteria: To avoid unintended calls, use a specific sheet or a filtered view. For example, you might have a Google Form collecting sign-ups – connect its response sheet to this Zap. Or, if using an existing sheet, add a filter or condition: e.g., only trigger if a certain column is “Ready” or a checkbox is TRUE. You can implement this by using the Filter by Zapier step after the trigger (e.g., “Only continue if Call = TRUE” in the row data). This prevents calls on every single add, unless explicitly marked.
Phone number formatting: Ensure that the sheet consistently stores phone numbers in a format Awaz can dial. Including country code is important for international. You might use a Zapier Formatter step (Text -> Phone) to format numbers to E.164 format (e.g., +441234567890 for UK). This reduces chances of call failures.
Awaz.ai call scheduling: If you mapped a future time, note that Awaz will queue the call. It’s a good idea to make sure the timezone is correct. If your Google Sheet stores local times, convert them to a universal format before sending to Awaz. You can add a Formatter -> Date/Time step to parse the sheet time and output in UTC ISO string that Awaz expects.
Avoid infinite loops: If you use a Google Sheet that is also being updated by another Zap (or by the call logging Zap from Scenario A), ensure you aren’t triggering a Zap on those updates, which could cause recursion. For instance, if Scenario A and B use the same sheet, a new call log row could trigger another call – to prevent this, use separate sheets or add a condition like a specific column to differentiate data.
Testing without spamming real calls: While developing, you might want to turn off your Awaz agent’s ability to actually speak or route to a dummy flow, or use a dummy phone number, so you can simulate the Zap end-to-end without calling real customers. Once confident, switch to real numbers.
Zapier Task History: If an expected call didn’t happen, check Zapier’s task history for errors. Common issues: Google Sheets trigger didn’t fire (was the row truly new? If using “New or Updated Row”, Zapier might not detect purely manual edits unless a specific cell changed or a new row added), or Awaz returned an error (like “Invalid phone number” or “Agent unavailable”). Address those accordingly (fix data or ensure the Awaz agent ID is correct etc.).
Awaz.ai Logs: Also check your Awaz.ai dashboard/call logs. Awaz might show if the call was scheduled or if it failed to initiate. This can provide insight (e.g., “Call blocked due to invalid number” or “No credits remaining”).

Best Practice Tip: Confirmation and Follow-ups

When an Awaz call is triggered from a sheet entry, you might want to update that Google Sheet row (or another sheet) with the outcome. For instance, you could use Awaz’s Agent Trigger to catch if the call was answered or a certain result occurred, then use that to update the sheet (similar to Scenario A, but updating the original row or a status column). This is advanced, but it closes the loop by marking leads as called. You could accomplish it by including an ID in the sheet and using Zapier’s Update Spreadsheet Row action in the call-completion Zap to mark status.