About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I get a new row in Google Sheets to auto-populate data into a separate Google Sheet?
Best answer

How do I get a new row in Google Sheets to auto-populate data into a separate Google Sheet?

  • 11 October 2022
  • 3 replies
  • 964 views
S

I have a list of rental properties organized on a CSV file.  I’d like the data to auto-populate onto a google sheet so that I draft multiple letters simultaneously but I can’t seem to figure out out.

 

Below is what I’ve done so far.

  1. I’ve transferred the CSV data to a new google sheet with a header as Tenant List
  2. I’ve created a form on google sheet with no header as Increase Notice
  3. In Zapier I’ve performed the following
    1. Line 1: New or Updated Spreadsheet Row: to identify new data Tenant List
    2. Line 2: Get Many Spreadsheet Rows: to identify Address row in Increase Notice
    3. Line 3: Get Many Spreadsheet Rows: to identify Rent row in Increase Notice
    4. Line 4: Get Many Spreadsheet Rows: to identify Deposit row in Increase Notice
    5. Line 5: Update Spreadsheet Row: to get data from new row in Tenant List to populate in Increase Notice

At Line 5 however I’m not able to choose the specific cell data from Tenant List to populate into the identified rows for Increase Notice.

 

Is what I’m attempting not possible?  What might I be missing?

 

Hope to hear from you soon!

icon

Best answer by chanelle 17 October 2022, 19:57

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

MohSwellam
Userlevel 7
Badge +8

Hi @SarapObama 

 

If I understand correctly, the tenant list (which is the trigger) should be sent Increase Notice table so you should actually create a new row instead of Update. 

Founder of GeekyAir.com
S

Okay so if I’m understanding correctly it should be as below?

  • Trigger: New or updated spreadsheet row (Tenant list)
  • Action: Create Spreadsheet Row (Increase Notice)

I’ve updated the app to reflect this but it just creates a new blank row at the bottom of my Increase notice.

 

What do I need to do to perform the following actions?

  1. Target the custom row in Increase Notice identified as “Rent row in Increase Notice”
  2. Update custom row with rent data from Tenant list
chanelle
Userlevel 7
Badge +8

Hi @SarapObama 👋🏾, let’s try this. Can you go into your sheets and create custom column headers? 

Your initial set up is fine, but you’ll want to be able to choose a specific trigger column to pull from the specific data cells from your Tenant List. See below, my chosen column header is Column Alpha: 

From there, you’ll keep Create Spreadsheet Row as your Action, but we will connect the custom column headers from both sheets. Essentially, you’ll be mapping over each data cell to be replicated in your chosen Google Sheets doc. 

I’ve tested this out, and it appears to be working with about a 5 minute delay. Let me know if this helps!

Terms & Conditions