cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GlenwoodMedia
Level: Power Up

Squarespace Forms

Websites built on Squarespace have the option of storing forms in Google Sheets.  Each time a client fills in a form, a row is added to a Google Sheet with all of the form responses in different columns.

I need to find a way to copy that data from a Google Sheet to an Excel File in Sharepoint.

 

Squarespace forms trigger emails, so the trigger event for Flow is easy enough - it's the 'copy and paste' from the Google Sheet to the Excel Sheet that is the problem.

Any ideas?

4 REPLIES 4
Community Support Team
Community Support Team

Re: Squarespace Forms

Hi @GlenwoodMedia,

 

Do you want to copy data from Google Sheet to an Excel file in SharePoint?

Please check the following flow for a reference.

For testing, it is triggered by Button.

Then Get rows from Google sheets.

Add an Excel online action Add a row into a table to insert items from Google sheet to Excel. To use Excel files saved on SharePoint library, please make sure select Location to your SharePoint site.

Image for your reference.

1.PNG

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GlenwoodMedia
Level: Power Up

Re: Squarespace Forms

Thanks, Mabel

 

I tried that yesterday and it didn't work.  And then I tried it again today and it did!! - all of the fields in the Google Sheet became options to fill the Excel rows. (maybe it was a propagation thing that caused the delay?)

 

But...it copies the entire sheet, every time there is an email.

Do you know if there is a way to copy only the last row in the Google Sheet with data each time an email is received?

Community Support Team
Community Support Team

Re: Squarespace Forms

Hi @GlenwoodMedia,

 

Thanks for updating.

To get the last row from Google sheet, please use the last function.

Under the action Get rows, add the SharePoint action Create item.

Enter code likes below for each field:

 

last(body('Get_rows')?['value'])?['Title']

last(body('Get_rows')?['value'])?['number']

 Please make sure you do use the correct column name from the Google sheet.

1.PNG

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GlenwoodMedia
Level: Power Up

Re: Squarespace Forms

Hi Mabel

 

I really do appreciate your help with this! 🙂

So I tried to run that with just one of the columns from the Google Sheet - the first one - "Submitted On" is the title on the Google Sheet.   I think I'm missing something in the syntax of these expressions.  This is the error message I got back.

InvalidTemplate. Unable to process template language expressions in action 'Create_item' inputs at line '1' and column '2521': 'The template language expression 'last(body('Get_rows')?['value']?['Submitted_On'])' cannot be evaluated because property 'Submitted_On' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,283)