I am trying to connect a Hubspot form to Google Sheets. When the information that I want is added to the google sheets (name, email, product), other columns for which I don’t want to add any information from the form but do use the added information as an input (formulas) become blank instead of outputting the intended values. How can I fix this?
Best answer by william
View original
+14
Hi
Are you able to provide a specific example so that we can better understand what you are trying to do?
Perhaps provide screenshots to add context.
FYI: Keep in mind GSheet adds new rows (different than populating an existing empty row) for the GSheet Add Row action.
Make sure to review the available help docs for GSheets with Zap: https://zapier.com/apps/google-sheets/help
+6
Hey
Were you able to get things working, or can we still help out here?
When working with zaps and spreadsheet formulas, you’ll want to either include the formula directly in the zap, or you’ll want to use one sheet for your formulas and another sheet for the zap to send data to. This way you can import the data from the zap sheet into your main sheet and run the formulas on that data without any worry that the zap will clear those formulas.
It won’t always be possible to include the formulas directly in the zap, so I typically recommend using the two sheet method so the zap sends data to it’s own sheet and the formula sheet pulls data from the zap sheet using ImportRange() or something similar.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
