Best answer

Add new row in Spreadsheet from a daily Google Form

  • 23 April 2021
  • 5 replies
  • 26 views

Hi,

I’m sending every day new Google Form for daily “working hours” that each employee have to fill and i would like to automatize the questions on a personal and always the same big Google spreadsheet (for each employee).

 

How can i manage it?

Thanks!!

icon

Best answer by Troy Tessalone 23 April 2021, 16:40

View original

5 replies

Userlevel 7
Badge +14

Hi @Galels 

FYI: GForms can be configured to automatically save data to a GSheet, without the need for Zapier: 

https://support.google.com/docs/answer/2917686?hl=en

 

 

Hi @Troy Tessalone ,

Right! Thanks!

And any tips on how I can schedule this Form in a everyday mail to everyone (automatically)?

 

Thanks!

Userlevel 7
Badge +14

@Galels Can you please elaborate?

Userlevel 7
Badge +12

@Galels 

You can send a scheduled email everyday with a link to the google form. 

In your google form, you can get a link from the Send button. 

In Zapier, you can set up a trigger using Schedule by Zapier and as an action use your preferred email vendor or Zapier’s email action. 

Here is a link to a template integration between Schedule by Zapier and Gmail

 

In your email, you can include a link to the google form. 

Userlevel 3
Badge +6

Hey @Galels, hope you’re well, I juste wanted to check in here!

Were you able to get things working with the info from GetUWired, or can we still help out?

Reply