Exporting Product Line Items and Cart Attributes to Google Sheets

Technical Q&A
1

I am trying to automatically export Product Line Item data and Cart Attributes Data to Google Sheets

Currently using Integromat which does most data - but doesn’t support line items…

Does anyone have any suggestions?

2

@Scott-WebWizard

no sorry its not possible

3

When you refer to product line item data, what are you referencing specifically? Do you mean line item attributes found on an order?

4

@CloudlabSam

can you try this

https://ui-elements-generator.myshopify.com/pages/line-item-property

5

Yes. That works and I understand that ends up being line item properties at the order level.

Our Report Toaster app can report on these and then export them to CSV. Please see this article.

https://support.cloudlab.com/portal/en/kb/articles/reporting-on-line-item-properties-and-note-attributes

6

@CloudlabSam

thanks for update

7

Hey @Scott-WebWizard ,

Our app EZ Exporter might be able to help with this as well and can export Lineitem Properties and Cart Attributes (aka Note Attributes) combined in one column or in separate columns.

We also have a direct Google Sheets integration so you can push the data directly to an existing Google Sheets spreadsheet and schedule it to occur automatically.

Please feel free to reach out to us if you have any questions on this.

8

Hi Johnathan

Based on your comments I was actually able to find the correct settings in Integromat and got the issue solved in their system

I will keep your system in mind for future integrations :slightly_smiling_face:

many thanks

9

No problem Scott, glad to hear you got it sorted out! :slightly_smiling_face:

10

Hi Scott

I am actually facing the same issue. How did you solve it ?

Best

Daniel

11

Hi Daniel

Using Integromat with Note Attributes and LineItem Properties Array see screenshot below

ScottWebWizard_0-1649808030421.png
ScottWebWizard_0-1649808030421.png1485×816 57.2 KB

12

Hi Scott

Thanks a lot that s a huge help.

Best